Calculate Top 10 total

[nleuck_101]

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?

[ajaybabuinturi]

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.

[nleuck_101 · Accepted solution]

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.