Forum Discussion
Continued ContributorCalculate Top 10 total
Hello All,
I'm trying to calculate the top 10 total count for another measure where I see what percentage the top 10 account for the total count. Below I will list out my measures. Any help would be greatly appreciated.
Total Count = COUNT(Table[Id])
Total Subtopic Rank = RANKX(ALLSELECTED(Table[Subtopic]), [Total Count],,DESC)
Top 10 Subtopics Count = CALCULATE([Total Count], FILTER(Table, [Total Subtopic Rank] <= 10))
My measure [Top 10 Subtopics Count] total is 10,453. This is incorrect, that's the total of all my subtopics. I would have expected it to be 3,825, which is the total count of my top 10 subtopics. What am I doing wrong?
Well, I was able to solve it. I created a variable for my top 10 first.
VAR _Top10 = TOPN(10, ALL(Table[Subtopic]), [Total Count], DESC) RETURN CALCULATE([Total Action Item], FILTER(Table, Table[Subtopic] IN _Top10))
Then I divide that measure with my total count to get the percentage I was expecting.
2 Replies
nleuck_101Well, I was able to solve it. I created a variable for my top 10 first.
VAR _Top10 = TOPN(10, ALL(Table[Subtopic]), [Total Count], DESC) RETURN CALCULATE([Total Action Item], FILTER(Table, Table[Subtopic] IN _Top10))
Then I divide that measure with my total count to get the percentage I was expecting.- ajaybabuinturi
Super User
Hi nleuck_101,
Could you change your measures as below, I hope you will get the required result.Total Count = COUNT(Table[Id])Top 10 Subtopics Count = SUMX( TOPN(10, VALUES(Table[Subtopic]), [Total Count], DESC), CALCULATE([Total Count]))Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.
