Forum Discussion

DK-C-87's avatar
DK-C-87
Icon for Helper I rankHelper I
1 year ago
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...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    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?
Bibiano_Geraldo's avatar
Bibiano_Geraldo
Icon for Super User rankSuper User
1 year ago

Hi DK-C-87 ,
To ensure that the ranking is limited to the 21 rows shown in your visual, you can adjust your measure to better respect the current filter context.

Please consider this updated DAX and let me know if its all ok:

Measure = 
IF(
    HASONEFILTER(ProcesGBS[Proces]),
    RANKX(
        ALLSELECTED(ProcesGBS[Proces]),
        CALCULATE(
            SUM(ProcesGBS[Timer Norma RAW CM (ProcesID)]),
            FILTER(
                ALL(Stamdata),
                Stamdata[Plant] <> BLANK()
            )
        ),
        ,
        DESC,
        DENSE
    ),
    BLANK()
)