Forum Discussion

Gazsim44's avatar
Gazsim44
Helper III
6 years ago
Solved

Remove Rank from Table

Hi All,    I am struggling to remove a rank number from the total on a table. I have done this previously on other tables using HASONEVALUE but I dont know how, if possible to incorporate this in t...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi Gazsim44 

     

    Try this, 

     

    Rank (Var to Prior Year) =
IF (
    HASONEVALUE ( 'PL Data'[Branch] ),
    RANKX (
        FILTER (
            ALLSELECTED ( 'PL Data'[Branch] ),
            NOT ( ISBLANK ( [Var. to Prior Year EUR] ) )
        ),
        [Var. to Prior Year EUR]
    )
)

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Gazsim44 

 

Try this, 

 

Rank (Var to Prior Year) =
IF (
    HASONEVALUE ( 'PL Data'[Branch] ),
    RANKX (
        FILTER (
            ALLSELECTED ( 'PL Data'[Branch] ),
            NOT ( ISBLANK ( [Var. to Prior Year EUR] ) )
        ),
        [Var. to Prior Year EUR]
    )
)

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • Gazsim44's avatar
    Gazsim44
    Helper III
    6 years ago

    Many thanks Mariusz that works perfectly!

     

    All the best