Forum Discussion

Ngh25's avatar
Ngh25
Regular Visitor
2 years ago

Ranking a table based on 2 dynamic selected years using Max function

Hello Ashish_Mathur  I am trying to rank my Operations table based on 1 or more dynamic years chosen by the user from my Year slicer.  This is my Operations table based on 2023 selection :  La...
Tips and Tricks
Ngh25's avatar
Ngh25
Regular Visitor
2 years ago

Hi Anonymous ! 
thank you for your answer but it doesn't work for me! 
The issue here, is that I am  working in direct query mode, so I can't add tables or more links in the data model, the only way I have is to do it by creating a measure! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Ngh25 

    It will not affect it, if you cannot create the table, you can use the measures I offered directly, it can work.

    Max_value = CALCULATE(MAX('Table'[Nb_test]),ALLSELECTED('Table'),'Table'[Lab] in VALUES('Table'[Lab]))
    Rank = RANKX(ALLSELECTED('Table'[Lab]),[Max_value],,DESC)

    Output

     

    Best Regards!

    Yolo Zhu

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