Ranking a list of values

[randyvdr]

Hello Power bi Community

Could you please help me with the following challenge:

I have the following  data:

Names	Values
Bird, Dog, Cat	4
Cat, Fish, Bird	2
Dog, Elephant, Lion	3
Lion, Bird, Cat	1

And I want to rank each one of the names by sum of values, the result should be something like this:

Names	Values
Dog	7
Cat	7
Bird	6
Fish	2
Elephant	3
Lion	1
Mouse	1

[Bmejia · Accepted solution]

The first thing you want to do is transform your data you can not rank it in the format you have it with commas without getting to very complex calculations to extract the data.

Transform the data:

Split Data

Unpivot the data (Remove any spaces)

Group By

Apply the changes then create a measure like the sample below to give you the rank

Rankx = RANKX(ALL(RankAnimals[Animals]),CALCULATE(SUM(RankAnimals[Values])),,ASC,Dense)