Rank in card visual

[coolstrike]

Hello,

I am trying to have a card visual to rank customer sales. One visual for customer rank by sales amount for the whole organisation and another for customer rank of same customer but for the account manager in charge.

The page has a slicer to select the customer.

Selecting the customer should display the customer rank for the organstion and rank for the account manager for the customer.

One table has the customer and account manager and the sales details table has the sales transactions.

So for the selected customer sales rank could be 50 for the whole organisation but 20 for the account manager based on total sales.

Any help is appreciated.

thanks

[harshnathani]

Hi @coolstrike ,

Please share some sample Data for this.

Regards,

Harsh Nathani

[coolstrike]

Cust	Acct Manager	Doc	Amt
HUCO	RDC	IN34968	12625
NUPL	RDC	IN45603	71035
HUCO	RDC	IN95726	5438
NUPL	RDC	IN32103	37016
PLAP	YSA	IN96562	5685
ORIC	YSA	IN93719	87097
NUPL	RDC	IN45970	98700
PLAP	YSA	IN30498	7830
HUCO	RDC	IN67967	39870
ORIC	YSA	IN12359	84712

Customer	Acct manager
HUCO	RDC
NUPL	RDC
ORIC	YSA
PLAP	YSA

[harshnathani · Accepted solution]

Hi @coolstrike ,

You can create 2 measures.

Rank Sales Organisation = RANKX(ALL(Customer[Cust]),CALCULATE(SUM(Customer[Amt])))

Rank Sales Manager = RANKX(FILTER(ALL(Customer[Cust],Customer[Acct Manager]),Customer[Acct Manager] = MAX(Customer[Acct Manager])),CALCULATE(SUM(Customer[Amt])))

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[coolstrike]

Hi @harshnathani 

thanks for your reply and solution. Much appreciated