Rankx returning duplicates for different amounts

[lucasuzeda]

Hello,

I am trying to get the rankings for the amount of hours. I proceeded with the expressions: 

- Downtime = sum(Sheet1[Duration (hours)])

- Ranking Downtime Alarm = 

    if( 

        hasonevalue(Sheet1[Alarm Code Final]),

    rankx(

        ALLSELECTED(Sheet1[Alarm Code Final]),

        [Downtime],,DESC,Dense)

    )

However, I am getting odd results:

For the case below: Rank 5 does not appear, then 7 comes 2 times. There's no 9, 10 appears two times. There's no 14 and 15 appears two times. These duplicate rankings are not tied, they're different amount of the sum. And this goes on along the measure.

Could I get any support on this one?

[v-henryk-mstf]

Hi @lucasuzeda ,

Check the dax you wrote. For the above errors, it may be caused by the structure of the table model. Downtime = sum(Sheet1[Duration (hours)]). What does the field in the formula refer to? Can you provide a complete data model (delete sensitive information). I will answer for you as soon as possible.

Looking forward to your reply.

Best Regards,
Henry

[Jihwan_Kim]

Hi, @lucasuzeda 

I am not sure about how your whole data model looks like, but please check whether the [Alarm Code Final] is filtered by category or sub category.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/