How to apply rankx measure and filter for specific line item while keeping rank unfiltered?

[Dave24]

Is it possible to have the below Rankx formula filtered on specific peer without the rank showing up as 1?

This is the data set for example, with Peer and Monthly Return being the load from external source.Rank of Total Peers QTD and Total Return QTD being the two measures above.

In PowerBI when using the Dax code below to show just the Target QTD Rank which should show 3, it shows 1.

Is there a solution to filter Target and have the rank show as 3?

Thank you!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how you will present the end result, but please try something like below if it suits your requirement.

Target Rank =
MAXX (
    FILTER (
        ADDCOLUMNS (
            ALLSELECTED ( 'Import to Powerbi'[Peer] ),
            "@rank", [Rank of Total Peers QTD]
        ),
        'Import to Powerbi'[Peer] = "Target"
    ),
    [@rank]
)

[Dave24]

Hi  Jihwan,

That is perfect, giving the correct result! I appreciate it! 🙂