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))

Whitewater100's avatar
Whitewater100
Solution Sage
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   it works for 1 row. but, i need it to work for multiple rows total. see screen shot. 

 

  • Whitewater100's avatar
    Whitewater100
    Solution Sage
    4 years ago

    OK. Maybe the INSCOPE is better:

     

    Rank In Scope = IF(

    ISINSCOPE(dim_sites[Site_District]), RANKX(ALL(dim_sites[Site_District]),

    [Percent]),

    IF(

    ISINSCOPE(dim_sites[Region]),

    RANKX(ALLSELECTED(dim_sites[Region]),

    [Percent]),

    IF(

    ISINSCOPE(dim_sites[Division] ),

    RANKX(ALLSELECTED(dim_sites[Division] ),

    [Percent])

    )

    )

    • 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..