Finding the Rank based on 2 Slicers

[Anonymous]

Hi there,

I hope I can explain myself properly here...

I have 2 slicers on my page that is pulling the same data. One is single select and one is multiple select.  This allows me to run comparisons of one person to the averages of some selected contemporaries.

An example of this is using one card showing the number of phone calls answered within a selected time frame and another card showing the average across a select group of people.

What I now need is to show where that one person (1st slicer) ranks in the list of individual achievements from the selected people in the 2nd slicer.

Any assistance would be awesome!!

Thanks

Peter

[v-jayw-msft · Accepted solution]

Hi @Peter_Lithgow,

Please check following steps as below and see if the result achieve your exception:

1. Create calculated table:

    name = DISTINCT('scores'[name])

2. Create measures:

    sum = SUM(scores[scores])

    rank_selected =

    var select_name = SELECTEDVALUE('name'[name],BLANK())

    var select_rank = RANKX(ALLSELECTED(scores[name]),[sum],,DESC)

    return

    IF(select_name = MAX(scores[name]),select_rank,BLANK())

3. Result would be shown as below:

BTW, Pbix as attached. Hopefully works for you.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[Anonymous]

@v-jayw-msft - you ripper!!  This is exactly what I was wanting to do.  Thank you so very much!

Peter