Forum Discussion

HarishMJ's avatar
HarishMJ
Regular Visitor
1 year ago
Solved

Ranking not working as expected

  Hi everyone, I’m facing an issue with the RANKX DAX formula and would greatly appreciate your help! Here’s the scenario: I have created the following RANKX measure, which works perfectly in a t...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    HarishMJ 

    measure:

    RankX =
    IF (
    ISFILTERED ( Sheet1[CIF] ) || ISFILTERED ( Sheet1 ),
    RANKX (
    ALLSELECTED ( Sheet1[CIF] ),
    CALCULATE ( SUM ( Sheet1[Amount] ) ),
    ,
    DESC,
    DENSE
    ),
    RANKX (
    ALL ( Sheet1[CIF] ),
    CALCULATE ( SUM ( Sheet1[Amount] ) ),
    ,
    DESC,
    DENSE
    )
    )

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

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

Hi HarishMJ ,

Please update your DAX to something like this:

RankX = 
IF (
    ISFILTERED(Sheet1[CIF]),
    RANKX(
        ALL(Sheet1[CIF]),
        CALCULATE(SUM(Sheet1[Amount])),
        ,
        DESC
    ),
    RANKX(
        ALLSELECTED(Sheet1),
        CALCULATE(SUM(Sheet1[Amount])),
        ,
        DESC
    )
)


your final output will look like this: