Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears
I have a dashboard that I want show current year data (2019)
I wrote the expression like this and applied it in all my tables and charts:
sum({<Year={"$(=Max(Year))"},Area_Category-={"Test","Free ShortCode","Xtratime","ACS"}>}REVENUE)
but when I pick both 2018 and 2019 years together, my dashboard just show the 2019 value.
but when I choose one by one it shows correct
how can I fix this problem to show whole data when I choose both 2018,2019??
I attached my QV in this post.
Thank you
Try an expression which checks if you have made a selection in the Year field.... if it has then you use another expression otherwise a default expression which gives you the data for the max year. For example... this for New Sub(Count) expression
=If(GetSelectedCount(Year) = 0, num(sum({<Year={"$(=Max(Year))"},Area_Category-={"Test","Free ShortCode","Xtratime","ACS"}>}NEW_SUBSCRIPTION_COUNT), '#,##0'), num(sum({<Area_Category-={"Test","Free ShortCode","Xtratime","ACS"}>}NEW_SUBSCRIPTION_COUNT), '#,##0'))
Dear Sunny
thanks for your helpful response
as I applied the expression on my charts, it is not worked
would you please help