Remove Rank from Table

[Gazsim44]

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,  

[Mariusz · Accepted solution]

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]

Many thanks @Mariusz that works perfectly!

All the best