Forum Discussion

MbProg's avatar
MbProg
Icon for Helper II rankHelper II
10 years ago

Top N by different parameters

Hello, I have a dataset with very simple data: ProductID, Region, Value, Category. I wanted to rank the Products by their Value. So I did the following: Create Measures: 1. Total_Budget = SUM('Pro...
Need Help
Praful_Potphode's avatar
Praful_Potphode
Icon for Super User rankSuper User
8 months ago

Hi MbProg ,

 

try below measure:

Dynamic Rank = 
SWITCH(
    TRUE(),
    ISINSCOPE(Projects[ProductID]), 
        RANKX(
            ALLSELECTED(Projects[ProductID]),
            [Total_Budget],
            ,
            DESC,
            Dense
        ),
    ISINSCOPE(Projects[Region]), 
        RANKX(
            ALLSELECTED(Projects[Region]),
            [Total_Budget],
            ,
            DESC,
            Dense
        ),
    BLANK()
)

 

 

 

 

 

Sample PBIX

Please give kudos or mark it as solution once confirmed.

Thanks and Regards,

Praful