Forum Discussion
nleuck_101
Continued Contributor
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...
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.
nleuck_101Continued Contributor
Continued ContributorWell, 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.