Forum Discussion

SpanishEnjoyer's avatar
SpanishEnjoyer
New Member
1 year ago

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...
Need Help
Tips and Tricks
rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi 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.

SpanishEnjoyer's avatar
SpanishEnjoyer
New Member
1 year ago

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi SpanishEnjoyer ,

     

    I don't quite understand your grouping logic, if the room ordering 001 and 003 should be the same, they should both return 2.

     

    Please detail your needs and demonstrate the expected results.

     

    Best regards,
    Community Support Team_ Scott Chang