Forum Discussion
Using function Rank or Rankx for grouped rankings
Hello, I have two tables related to each other by ID. One table has information about dates when a equipment failed and how it did and the other table contains information about all equipments (id,c...
rajendraongole1
Super User
Super UserHi SpanishEnjoyer -Create a new measure that ranks the equipment based on the number of failures within its respective category
Rank_Per_Category =
RANKX(
ALLSELECTED('Table Equipments'[ID Eq]),
[Count_Failures],
,
DESC,
DENSE
)
create another measure for rank for each room as below:
Rank_Per_Room =
RANKX(
ALLSELECTED('Table Equipments'[ID Eq]),
[Count_Failures],
,
DESC,
DENSE
)
this way you can achieve, hope it works.
Thanks for your answer, but the new metrics works as the metric Ranking that is already created. It doesn´t rank the equipment by cathegory or room.