Forum Discussion
Need help with ranking
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! 🙂
Check
https://www.dropbox.com/s/ps1475oidzubmud/yearsalesemployerank.pbix?dl=0
I think category rank will do
Rank = RANKX(ALL(yearsalesemployerank[Name]),CALCULATE(SUM(yearsalesemployerank[Sales])),,DESC,Skip)
Ashish_Mathur My data is like this:
| Name | Sales | Year |
| A | 200 | 2018 |
| A | 26 | 2019 |
| B | 3456 | 2018 |
| B | 55555 | 2019 |
| B | 4 | |
| C | 5 | 2019 |
| C | 55 | 2018 |
| A | 767 | 2019 |
| C | 888 | 2018 |
| D | 899 | 2019 |
I have multiple sales by each person. So I am ranking them for each year. So I have a slicer with name and year. I want to show their ranking in a card as per each year and if year is not selected then combina ranking for 2018+2019 sales.
Hi,
Create a slicers for Year and Name. Write this measure
Total Sales = SUM(Data[Sales])
Rank = RANKX(ALL(Data[Name]),[Total Sales])
Hope this helps.
Ashish_Mathur thanks for your input but its not working. I have made a table with name, total sales and rank. Its ranking corrrctly in that. But when i am selecting name from slicer I am getting different rank in card. Even if I am selecting name from table its showing different rank in card. So in my table its rank 107 for a name but if i select that name then in card its showing 99.
Hi,
May be I am not clear with your requirement but please let me know the problem that you face in this PBI file.