Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Ranking where table does not have unique values

Hi, I'm working on a dataset where I want to rank based on a label. The table does not have unique values due to sales happening for the same label type in multiple countries at the same day. I've w...
Need Help
v-jinweili-msft's avatar
v-jinweili-msft
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Hi Anonymous ,

 

According my understanding, you want to sort article_count by each label and country.

If so, please create a measure:

 

measure = 
RANKX (
    FILTER (
        ALL ( 'planned_and_purchased' ),
        'planned_and_purchased'[Label ID] = MAX ( 'planned_and_purchased'[Label ID] )
            && 'planned_and_purchased'[country] = MAX ( 'planned_and_purchased'[country] )
    ),
    CALCULATE ( SUM ( planned_and_purchased[article_count] ) ),
    ,
    DESC,
    DENSE
)

 

Output:

 

If not, please share more information (tables, outputs) to help us clarify your scenario. Or share me with your pbix file after removing sensitive data.

 

Refer to:

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

How to Get Your Question Answered Quickly - Microsoft Power BI Community

 

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