Forum Discussion

lucasuzeda's avatar
lucasuzeda
New Member
5 years ago

Rankx returning duplicates for different amounts

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?

Need Help

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    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/

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    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