Forum Discussion

snph1777's avatar
snph1777
Helper V
6 years ago

Power BI - DAX language RANKX function for TOP 5 only

I have a Power BI table report as below.   Products (dimension column) ProductCount (measure) ProductRank (measure) Fridge 36 1 AC 30 2 Fan 28 3 Light 25 4 Chair 20 5 ...
Need Help
snph1777's avatar
snph1777
Helper V
6 years ago

Hello  mahoneypat 

 

I am using this in a visual, so really don't need a total;  I am planning to show this in a pie chart.

 

Can i do this, showing the 'Others' as a 6th rank ?  Will I get 17 for Others?

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

This approach wouldn't work in a pie chart.  You will have to do one of the suggestions before to get an "Other" value in your products column.

 

Regards,

Pat

 

  • snph1777's avatar
    snph1777
    Helper V
    5 years ago

    @jdbuchanan71

     

    Our client has finally agreed to create a calculated tablle.

     

    Will update you in the next day or so.

     

    Thanks very much. Appreciate your help so far.

     

    Will keep you posted.

  • snph1777's avatar
    snph1777
    Helper V
    5 years ago

    Thanks for the clarification. Will keep you posted.