Forum Discussion

Stemar_Aubert's avatar
Stemar_Aubert
Icon for Resolver I rankResolver I
6 years ago
Solved

Run RANKX on partial data, and keep ranking in filtered tables visuals.

Hello everyone,   I have a question regarding RANKX(). My report consists of a leaderboard ranking different Districts based on a calculated measure (YoY Growth in %). The tricky thing is that I mu...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Stemar_Aubert ,

     

    You may modify your measure using dax below and check if it can meet your requirement:

    Rank =
IF (
    HASONEVALUE ( Local[DISTRICT] ),
    RANKX (
        FILTER (
            Local,
            Local[Custom] = 0
                && Local[DDISTRICT] = EARLIER ( Local[DISTRICT] )
        ),
        FPins[PINS YTD YoY Δ]
    ),
    "-"
)

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

Stemar_Aubert ,

 

You may modify your measure using dax below and check if it can meet your requirement:

Rank =
IF (
    HASONEVALUE ( Local[DISTRICT] ),
    RANKX (
        FILTER (
            Local,
            Local[Custom] = 0
                && Local[DDISTRICT] = EARLIER ( Local[DISTRICT] )
        ),
        FPins[PINS YTD YoY Δ]
    ),
    "-"
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.