Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Ranking Total Issue.

Hi All, I'm having incorrect Rankx Total on my measure whenever i filter on fiscal Year 2022, then when i filter fiscal year 2021 it works pperfectly. The RankTotal changes to 13 which is incorrect ...
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hi:

    Would this streamline it a bit? For each level

     Site Rank = IF (
    NOT ( ISBLANK( [Percent] ) ), RANKX(ALL(dim_sites[Site_Name] ), [Percent],  DESC))

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Whitewater100  The incsope didn't work either , the first code is better. can we not rank blanks for first code. 

 

Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

Hi lklizo:

If possible, would you be able to send me reprentative data? I will get it but easier if I can see your set up. Thanks for your patience..