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

DK-C-87 

Here's a refined measure that you can use:

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

Let me know if you have any further questions or need additional adjustments!

 

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

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

     

    Your measure returns this for me :


    A small different, but still not solved - do you have a suggestion ?