Forum Discussion

hannahGala's avatar
hannahGala
Advocate I
8 years ago
Solved

RANKX excluding blanks

Hiya all,   I've not posted before, apologies if this isn't in the right place.   I want to rank clubs by their YOY (year on year) variances - however there are some which may not have any sales ...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    hannahGala,

     

    You may refer to DAX below.

    YOY Rank =
IF (
    NOT ( ISBLANK ( [YOY] ) ),
    RANKX (
        FILTER ( ALLSELECTED ( 'Core ClubsVW'[Club] ), NOT ( ISBLANK ( [YOY] ) ) ),
        [YOY]
    )
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

hannahGala,

 

You may refer to DAX below.

YOY Rank =
IF (
    NOT ( ISBLANK ( [YOY] ) ),
    RANKX (
        FILTER ( ALLSELECTED ( 'Core ClubsVW'[Club] ), NOT ( ISBLANK ( [YOY] ) ) ),
        [YOY]
    )
)
madawak's avatar
madawak
Frequent Visitor
7 years ago

Thanks Sam.

 

Regards,

Madawa