Need help with ranking

[Vish24]

Hello,

I am really struggling in ranking my data. I have data like this:

Name   Sales  Year

A           100    2019

A           50     2019

A           25     2018

B          100    2019

B          75      2018

C          20     2019

B          45     2018

I have Sales by Many people with different years. One Person has many sales in a year. Now, I want to rank them for their sales by year. I am making a slicer for Names and Year. I want to show the ranking as per the selected name and year.

So my data should be rank separately for each year.

Please help! 

[JarroVGIT · Accepted solution]

Hi @Vish24 ,

You can use a measure like this:

Measure = 
VAR _tmpTable = SUMMARIZE(ALLSELECTED(Table1), Table1[Name], "SalesTotal", SUM(Table1[Sales ]))
VAR _rankedTable = ADDCOLUMNS(_tmpTable, "Rank", RANKX(_tmpTable, [SalesTotal], , DESC, Dense))
RETURN
MAXX(FILTER(_rankedTable, [Name] = SELECTEDVALUE(Table1[Name])), [Rank])

Resulting in a visual like this:

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂