Forum Discussion
Top N Table
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 Zhi
If 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.
