Forum Discussion
Solved
TOPN dax function as variable
Need to show top 5 services in table visual. Service Name Count Total Count Apple 43 346 Samsumg 67 346 mi 80 346 oppo 84 346 google 72 346 Measure written we...
Hi raj777karthik ,
OK, I know the reason of the problem.
Please try following DAX:
Rank = IF(HASONEVALUE('Stack Tags'[Service]),
RANKX(ALL('Stack Tags'[Service]),[Count],,DESC,Dense)
)Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thanks Rank is working fine as expected,but the total count measure is returning all the values.
Total count = CALCULATE([Count],FILTER(ALL('Stack Tags'),'Stack Tags'[Rank]<=5))
Hi raj777karthik ,
Can you tell me how the [Count] measure did you write?
It's better to share with me a screenshot of the original data (hide sensitive information).
Best regards
Yadong Fang
Measure written:
Count = COUNT('Stack Tags'[Service])Rank = IF(HASONEVALUE('Stack Tags'[Service]),RANKX(ALL('Stack Tags'[Service]),[Count],,DESC,Dense))Total count = CALCULATE([Count],FILTER(ALL('Stack Tags'),'Stack Tags'[Rank]<=5))Thanks Yadong.Its working fine.