Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic ranking based on slicer selection

Hi All -- Need one help with dynamic ranking based on slicer selection. Link has the PBIX file along with data. What I am trying to see is based on my year / month / quarter selection it should give ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    It works fine.  See the highlighted portion in the image

smpa01's avatar
smpa01
Community Champion
6 years ago

Anonymous  please try this and test the output

 

Measure 6 =
RANKX (
    CALCULATETABLE (
        VALUES ( Sale[Sales Person] ),
        FILTER (
            ALLSELECTED ( Sale ),
            Sale[Date].[Year] = SELECTEDVALUE ( Sale[Date].[Year] )
        )
    ),
    CALCULATE (
        DIVIDE ( CALCULATE ( SUM ( Sale[Sales] ) ), CALCULATE ( SUM ( Sale[Target] ) ) )
    ),
    ,
    DESC,
    DENSE
)

Big thanks to Zubair_Muhammad