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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

So I was able to fix the rankings not being the same by changing the Value Rank Across Selection measure to being this:

 

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

 

I dont really understand what is happening but it seems to be working. I still am not sure how to accomplish my other question.