Forum Discussion

Helper III

2 years ago

Solved

Rankx Ignore Blanks

Hi all , I have a condional Column that returns the device names connected to a specifc customer For example Store Name Usages Device 1 12 Device 2 14 14 Device 4 19 ...

Need Help

Anonymous
2 years ago
Hi JamesBurke ,

Sorry, please change the DAX into this:

Rank = VAR _RANK = RANKX(FILTER(ALL('Table'), 'Table'[Store Name] <> BLANK()), [Measure],,DESC,Dense) RETURN IF( MAX('Table'[Store Name]) <> BLANK(), _RANK, BLANK() )

The final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rankx Ignore Blanks.pbix26 KB

Anonymous

Not applicable

2 years ago

Hi JamesBurke ,

Sorry, please change the DAX into this:

Rank = 
VAR _RANK =
RANKX(FILTER(ALL('Table'), 'Table'[Store Name] <> BLANK()), [Measure],,DESC,Dense)
RETURN
IF(
    MAX('Table'[Store Name]) <> BLANK(),
    _RANK,
    BLANK()
)

The final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Rankx Ignore Blanks.pbix26 KB