Rankx gets recalculated

[pbiinterel]

I am having a issue in power bi wrt to ranking. I have a performance measure which is a  percentage for each Sales Manager ( SM)Each SM belongs to a region. 

We have to create a ranking at overall level and at rank the region separately. 

I created two measures one at SM level and other at region level to calculate the same. Individually it works fine. 

When the SM views the rank, it gets recalculated instead of showing the actual ranking at the company level. 

For ex. Region America is at 2nd position and the SM's are at 1,15,16 rank. But when filter applies/ or when SM sees based on their roles it becomes region becomes 1 and the SM rank becomes 1, 2, 3. 

How to avoid thi s?

SM rank code

SMP Rank = RANKX(

FILTER(

ALL(Users),

Users[Abr]<>BLANK()

),

[NewQualityIndex],,desc,Dense)

Region code

SMP Rank region = RANKX(

FILTER(

ALL(Users[Region]),

Users[Region]<>BLANK()

),

[NewQualityIndex],,desc,Dense)

when role level or filter is selected  the rank gets recalucated

Please help it is urget

[v-xuding-msft]

Hi @pbiinterel ,

The picture you post  can’t be loaded so that I can’t create a sample for the scenario. I don’t known that what the column of Abr is and  the relationship of the data in the table. Can you please post the sample data and the expected result?  Then we can help you as soon as possible.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pbiinterel]

Hi

Abr is the abbrevation for each user we have . It basically defines who are the SM from the list of users we have. We use this filter to filter by Sales Manager wise who in turn belong to a region.

In the picture> Americas has 4 SM ( and Abr is their short form)