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?
DK-C-87's avatar
DK-C-87
Icon for Helper I rankHelper I
1 year ago

Your measure returns this for me:


Do you have a suggestion to why this is ? 

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Icon for Super User rankSuper User
1 year ago

Can you please share a sample file with no sensitive information?

 

Your screenshot is not whowing entire table.

 

You can upload a sample file in onedrive or other cloud and share the link for download here in comments.

 

 

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

    Sorry, I can't share sample file. 
    I am filtering on 3 columns and are only showing 1 of these three filtret columns in the visuals table - could it be the problem here ? 
    Maybe the measure should summarize first and then rank on that ?