Filter Top N and percentage of Total

[Anonymous]

Dear All,

I wanted Top 10 of my Products basis its Total Sales, so I used the visual filter to derive that. Now I want to know what % does this Top 10 contribute to Total Sales, please guide  

[v-zhangti · Accepted solution]

Hi, @Anonymous 

Sample data:

Measure:

Rank = RANKX(ALL('Table'),CALCULATE(SUM('Table'[Sales])),,DESC)

Measure = 
Var N1=CALCULATE(SUM('Table'[Sales]),FILTER(ALL('Table'),[Rank]<=10))
Var N2=CALCULATE(SUM('Table'[Sales]),ALL('Table'))
Return
DIVIDE(N1,N2)

Hope that helps you.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.