Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

RANKX Question Help Needed

So I have a data set of locations with their corresponding values and I want to be able to rank them across the whole company and then also across their geographic regions and also their size categor...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Anonymous 

1.  you could try to use ALLSELECTED instead of ALL in the formula

https://powerbi.istanbul/all-allselected-ve-rasyolar/

 

2. You could just use this simple formula

Value Rank Across Selection = IF (
    HASONEVALUE ( 'values'[Value] ),
    RANKX (
       ALLSELECTED(  'Org Mapping'[Org ] ),
        'values'[Value Measure],
        ,
        ,
        DENSE
    ),
    BLANK ()
)

 

Regards,

Lin