Forum Discussion
Solved
RankX on a table with multiple filters
I need this measure to give me a ranking from 1-21 in my visual, which it dosen't do at the moment Measure =
IF(HASONEFILTER(ProcesGBS[Proces]),
RANKX(ALLSELECTED(ProcesGBS),
CALCULATE...
In the screenshot below I am using the following measures. Notice that evaluated correctly.
Total Revenue ALLDATES 2023 = CALCULATE ( [Total Revenue], FILTER ( ALL ( Dates ), Dates[Year] = 2023 ) ) RANK = RANKX ( ALL ( Category[Category] ), [Total Revenue ALLDATES 2023], , DESC, DENSE )Now, if i add another column, the rank for the column in rankx and the additional column is evaluated differently.
Things to check:
- are you using just the column specified in the rankx measure or are there more columns?
- is the expression the rank is based on returning the correct value?
You mean my visual 🙂
Yes, I am using the Proces column in my visual - it is the first column in the visual.
In the screenshot below I am using the following measures. Notice that evaluated correctly.
Total Revenue ALLDATES 2023 =
CALCULATE ( [Total Revenue], FILTER ( ALL ( Dates ), Dates[Year] = 2023 ) )
RANK =
RANKX (
ALL ( Category[Category] ),
[Total Revenue ALLDATES 2023],
,
DESC,
DENSE
)
Now, if i add another column, the rank for the column in rankx and the additional column is evaluated differently.
Things to check:
- are you using just the column specified in the rankx measure or are there more columns?
- is the expression the rank is based on returning the correct value?
Things to check:
- are you using just the column specified in the rankx measure or are there more columns?
- This question did it for me 🙂
- is the expression the rank is based on returning the correct value?
Thank you so much for your help !
- are you using just the column specified in the rankx measure or are there more columns?