Forum Discussion
TOP N Column Sum without Filter
Hi,
Images do not appear in your latest post. Anyways, i wrote these 3 measures and dragged the third one to a card visual
Total = SUM(Tabelle1[Value])
Top 30 = SUMX(TOPN(30,VALUES(Tabelle1[Categorie]),[Total]),[Total])
Top 30 % = [Top 30]/[Total]
The result is 51.77% = 2573.49/4971.31
Hope this helps.
That is not what I was looking for. I want that table with TOP N Filter but the sum in TOP N (and the percentage) should run on the Overall Sum of that column not the filtered TOP N sum. Like I said in my first post, if I have a sum of 1000 and my top 1 is 200 it has a percentage of 20%. But if i run the TOP N Filter the sum reduces to 500 and the top 1 with 200 has a percentage of 40%. That is a big difference (sure for the TOPs in correctly calculated but in overall it's not but i want the TOP Ns still weighted to the overall if it's possible, if not i will pass). :)
Thanks that looks awesome :).
Great to hear that. You are welcome.
Good Solution
Thank you.
