Forum Discussion

Maikeru's avatar
Maikeru
Helper II
6 years ago
Solved

RANKX with condition

Hi,   I am trying to create a RANKX measure on customers meeting a certain revenue conditions.     Rank top 100 = VAR Customer_list = FILTER( ALLSELECTED(Revenue[Customer]), [Revenue total] ...
Need Help
Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Maikeru ,

 

In your following DAX, can you use your "Customer_list" directly, rather using IN operator.

 Basically, rank your customer List and check. This should resolve the isssue.

VAR RANK_DESC = 
RANKX(
FILTER(ALLSELECTED(Revenue[Customer]), Revenue[Customer] IN Customer_list),
[Revenue total],
,
DESC)

  So, in above RANKX directly use CUSTOMER LIST.

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

Maikeru's avatar
Maikeru
Helper II
6 years ago

Thanks Pragati11.

 

I tried your idea, but the result was exactly the same.

    RANKX(
        FILTER(
            ALLSELECTED(Revenue[Customer]), 
            [Revenue total] < 50000000 && [Revenue total] > 30000000
            ),
        [Revenue total],
        ,
        DESC)