Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power BI unique Rank

Hi Folks,

So Iam working with power BI with the below data but my Rank measurement is not giving me accurante ranking. Total Callout is a measurement as well just a sum of the collumn "Callout". Would like to hear some from you guys.

 

 

 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    It is suggested to add an Index column in the Power Query as follows.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi, already checked them but the "VALUE" indicated which is the "TotalCallout" is a measure not a column. Which makes it a difficult to formulate.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    If entries in the Total callout column are the same, then why should they not be given a rank of 1?  If you do not agree with me on this, then why why should seating capacity get a rank of 3? (why not 1?)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    It is suggested to add an Index column in the Power Query as follows.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

    Could you tell me if your problem has been solved?
    If it is, kindly Accept it as the solution. More people will benefit from it.
    Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.


    Best Regards,
    Stephen Tao