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 this measure.

 

 

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

 

 

Many thanks for any assistance,  

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

     

2 Replies

  • 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