Dynamic Card with Team Rank question

[Anonymous]

I am trying to create a card visual within a report that will show a sales reps ranking within their sales team (sales leader) based upon who is selected in a slicer.

I have slicers for the Sales rep - and I have a table that has Sales Rep, Sales Leader, and Sales $ ammount - when a specific sales rep is selected in the slicer I want the card to show their specific rank amongst all reps that share that sales leader. Any idea how to accomplish this? I have created several Rankx measurements but cant get this one to work. 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your data model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Sales amount: = 
SUM( Data[Amount] )

Rank within a team: =
VAR newtable =
    FILTER (
        SUMMARIZE ( ALL ( Data ), TeamLead[TeamLead], SalesRep[SalesRep] ),
        TeamLead[TeamLead] = MAX ( Data[TeamLead] )
    )
RETURN
    IF (
        HASONEVALUE ( Data[SalesRep] ),
        RANKX ( newtable, [Sales amount:],, DESC )
    )

[Whitewater100]

Hi:

Can you try:

 Rank for Sales Person by Manage = RANKX(CROSSJOIN(ALL(Table[Sales Rep]), ALL(Table[Sales Manager])), 
[Measure you are ranking on],,DESC)

I hope this helps!