Sum sales and return rank of selectedvalue

[Anonymous]

Hi,

I have a sales table that looks similar to this table:

How can I return the rank of the selected sales person (selectedvalue), after all sales amounts have been summed up based on the sales person, e.g. the rank for selectedvalue = 1  should be 1, selectedvalue = 3  should be 2 and selectedvalue = 2  should be 3? 

I have tried using the rank function, but I am struggling to add the amounts first.

Thanks for any hints!

[parry2k]

@Anonymous read this for ranking and that will do it.

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

Interesting read, thanks for sharing. But how do I include the selectedvalue portion? I need this, because my table with the sales staff and my sales are not connected. 

[aj1973]

@Anonymous 

Create 2 measures:

Sales = CALCULATE(SUM(Sheet1[Amount]), FILTER(Sheet1,Sheet1[Sales Person ]))

Rank Sales Person= RANKX(ALL(Sheet1),Sales)

you can then use "Rank Sales Person" in a Card and sales person as in a slicer

[parry2k]

@Anonymous once it is ranked on all customers, then you can just slice by any customer and you will get a rank. You have to first rank it to get that going and then come to selectedvalue.