Forum Discussion

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I want to sort by Sal value

      • NickolajJessen's avatar
        NickolajJessen
        Solution Sage
        4 years ago

        Use index to rank based on sal

        Note that this is done on a dimesions table.


        Note this cal also be done without the support column: 

        RANKX(countries,
    CALCULATE(
    SUM('Table'[Sal])
))



        If this post solves your problem, accept it as a solution
        Appreciate your kudos

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous,

    You can also take a look at the following blog to create a custom sort table to apply specific sorting order based on the 'sort by column' property and table relationship:

    Custom Sorting in Power BI  

    Regards,

    Xiaoxin Sheng