Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Unable to sort dynamic measures within matrix

Hi,

 

I have created measure with SWITCH function where I have more measures in slicer and those are changing  in matrix as I can choose one or more of them. I table with indexes and name of measures and then selectedvalue measure and then measure with switch function which gives me result I need.

 

Nevertheless I use in matrix dimension for wich I need results - this works but I can not sort the choosen measures. which is problem because sometimes I can get emply values on the top and other down...

 

 

So in the table I need sort data by CA(T) or CA(C), etc.

 

Can anyone help? Is it even possible? I didn't find any solution on internet...

 

Many thanks for any ideas!

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , once column in the matrix is used. then you can only sort on Grand total on columns. or on the row column.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Ok, and is it possible to use in my switch measure somehow RANKX? So it would always gives me desceding sort when metric is shown in the matrix? At least I am thinking about some workaround...

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, have you found a solution? I have the same problem..

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi, unfortunately not. I dont think its currently possible with Power BI...