Forum Discussion
Display Totals as Percentages
Hi Anonymous ,
Sorry for my late reply, I've got your point. please kindly check below reults:
Rank = RANKX(ALL('Table'),CALCULATE(MAX('Table'[Population])))Measure = DIVIDE(CALCULATE(SUM('Table'[Population]),FILTER(ALL('Table'),[Rank]<=15)),SUM('Table'[Population]))Pbix attached: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/ESkDVYQ7q-1Dpj0wj0tLIGMBhSkwwTmSWy35ifb38bhlpw?e=CxoTcG
Community SupportHi Anonymous
I’m not quite sure about the percentage of total you want, in my sample, I created the table with category and total value, then show value as percentage of grand total. And filter the category using “TOPN”. Without new measure involved.
Result shown as below:
Best regards,
Dina Ye
Hi v-diye-msft your solution doesn't exactlysolve my problem.
I have my top 15 SKUs that I have got by applying the Top N filter. Now I need
(sum of the value of these top 15) divided by (sum of all the values)
And I don't know how to get that
- v-diye-msft
Hi Anonymous ,
Did you enable the option: show values as percentage of grand total? does this work?
Best regards,
Dina Ye
- v-diye-msft
Hi Anonymous ,
Any updates?
Best regards,
Dina Ye