cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
toomuchnetflix Occasional Visitor
Occasional Visitor

How to do a ranking given a prior condition?

How would I go about doing a ranking on PowerBI given a prior condition? 

Such as, how could I create a single column that would rank annual sales for companies in the same industry, rather than across all industries? 

 

Appreciate all the help in advance! 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: How to do a ranking given a prior condition?

Hi @toomuchnetflix,

 

To rank annual sales within each industry, you can create a calculated column use RANKX() function like below:

 

RankEachIndustry = RANKX(
             FILTER(
                 ALLSELECTED(Table1),'Table1'[Industry]=EARLIER(Table1[Industry])
                           ),
                 'Table1'[Annual Sales],
                 ,1)

 

q4.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
bblais Member
Member

Re: How to do a ranking given a prior condition?

Moderator v-qiuyu-msft
Moderator

Re: How to do a ranking given a prior condition?

Hi @toomuchnetflix,

 

To rank annual sales within each industry, you can create a calculated column use RANKX() function like below:

 

RankEachIndustry = RANKX(
             FILTER(
                 ALLSELECTED(Table1),'Table1'[Industry]=EARLIER(Table1[Industry])
                           ),
                 'Table1'[Annual Sales],
                 ,1)

 

q4.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.