Forum Discussion
Top N Table
Hi,
I have a report where I would like to present data from my Top N customers (N is selected in the report). To present which customer that are my Top N is no problem (see visual with header AntalEval_name by name).
But the problem is to the present data connected to my Top N customers (see visual with header AntalEval_result by result).
The second visual is not correct. I would like to present the highlighted yellow data in the visual below. That is the result for my Top N customer (when N=3 my top customers are b, c, d, e, f, according to the above visual (b, c and e are in shared 3rd place)).
6 Replies
Hi rebecka,
I am not sure whether this is what you want, please refer to my sample to see whether it work or not. If this is not what you want, please correct me.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi dax !
The solution is not correct unfortunately.
The top N should rank the names according to the sum of amount, so Top 1 in your .pbix is name f. And therefore we want Better 5 when choosing Top 1 (since that is f's result).
Our Top 2 is d and f, and therefore should the pie chart show better 5 and worse 4 (the result of d and f).
Do you follow?
Can you fix that, would love if you can give it a try!
Best Regards, Rebecka
Hi rebecka,
I thought you want to get measure for second image, so I just create measure for result. If you want to get top N of name, you could use another measure like below
Measure = if(SELECTEDVALUE(slicer[top])>=RaNKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[amount]), ALLEXCEPT('Table','Table'[name])),,DESC,Dense),CALCULATE(SUM('Table'[amount]), ALLEXCEPT('Table','Table'[name])),BLANK())You could referto my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
