Forum Discussion
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...
Hi @v-xinruzhu-msft again and thank you for your answer !
1-Nb test is a measure not a column so I can"t use it directly this way!
2- I don't see the filter on the date range here, it's only taking the max value of nb tests but the filtrer doesn't work. I did it this way :
Max_value = CALCULATE(MAX(Nb_tests),ALLSELECTED('Operations'),'Operations'[lab] in VALUES ('Operations'[lab]))
Rank = RANKX(ALLSELECTED('Operations'[lab]),[Max_value],,DESC)
I need to use he date column from Operations based on the selected values of the calandar slicer, but I can"t achieve it correctly ! with 1 parameter it work successfully, but here, it doesn't !
I need to use he date column from Operations based on the selected values of the calandar slicer, but I can"t achieve it correctly ! with 1 parameter it work successfully, but here, it doesn't !