Forum Discussion

nleuck_101's avatar
nleuck_101
Icon for Continued Contributor rankContinued Contributor
1 year ago
Solved

Calculate 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...
Need Help
  • nleuck_101's avatar
    nleuck_101
    1 year ago

    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.

ajaybabuinturi's avatar
ajaybabuinturi
Icon for Super User rankSuper User
1 year ago

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.