Ranking a Group (filter on that group individually using a card visualization)

[Anonymous]

Hello,

I have used a DAX RANKX calcuation to rank a group of individuals based on performance.  Trying to build individual scorecards however, if i put my ranking in a card and filter/change my drop down of group the ranking doesn't seem to work.  Is there a way to use a card and filter on individual but still provide the proper ranking?

Please see image below 

[Anonymous]

Hi, @Anonymous 

Thanks @lbendlin.  Based on your description, I used part of the data provided by your image, as follows:

The DAX expression I use is as follows:

Rank =
RANKX ( ALLSELECTED ( 'Table' ), [Visit/Hours],, DESC, DENSE )

When I select the corresponding group in the slicer, rankx will recalculate:

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...