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

Kedar_Pande's avatar
Kedar_Pande
Super User
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