Forum Discussion

lisagon88's avatar
lisagon88
Frequent Visitor
8 years ago

Power BI Grand Total Order

Hello,

 

I am trying to do an order of the total on a table from highest to lowest. I want it to be able to work when using the filter/slicer when toggling between test column. I have provided a screen shot below of the table that shows the order that is calculated in. 


1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi lisagon88 ,

     

    Try the measure below and check if it can meet your requirement:

    Rank =
RANKX ( ALLSELECTED ( Table[Test] ), Table[Total],, ASC, DENSE )

    Regards,

    Jimmy Tao