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

Hi DK-C-87 

The rank is calculated in the context of other selected rows in the ALLSELECTED(ProcesGBS) table. Rank is supposed to be applied to a column and not a table.

  • DK-C-87's avatar
    DK-C-87
    Icon for Helper I rankHelper I
    1 year ago

    If I change the allselected to a column like this : 

     

     

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

     

     


    Then I get this result :