Top N

[Marac0105]

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 issue due to the fact that I have Other and Total rows, and in matrix Total should be sum of Totals from data set and Other should be variance of Total and sum of Top 10, Top 15, Top 25 (depending of the slicer selection).

Thanks in advance.

[Mariusz]

Hi @Marac0105 

To make it dynamic ie Top 10, Top 15 and top 25 it would have to be a Measure.

To make it display 1, 2, 3 ... 10 and Other it would have to be a Column.

You can not have both

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Marac0105]

Hi@Mariusz 

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 · Accepted solution]

@Marac0105 

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/RANKX-excluding-blanks/m-p/397656#M181491