Forum Discussion
Marac0105
7 years agoFrequent Visitor
Top N
Hi all, I have dataset (please see example) and trying to have a matrix which will show Top 10, Top 15, Top 25 customers, depending on slicer selection, ranked by Total amount column. I have an i...
- 7 years ago
You may take a look at the following post.
https://community.powerbi.com/t5/Desktop/RANKX-excluding-blanks/m-p/397656#M181491
Marac0105
7 years agoFrequent Visitor
HiMariusz
Thanks for your reply.
I was planning to use RANKX for Top N. Final output that I want to achieve is something like table below
I am also planning to use TOP N.
Main trouble here is that Other and Total from dataset is also ranked and included in TOP N.
v-chuncz-msft
Community Support
7 years ago
You may take a look at the following post.
https://community.powerbi.com/t5/Desktop/RANKX-excluding-blanks/m-p/397656#M181491