cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pbiinterel Frequent Visitor
Frequent Visitor

Rankx gets recalculated

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)
Inline image
 
when role level or filter is selected  the rank gets recalucated
 
Inline image
 
Please help it is urget
2 REPLIES 2
Community Support Team
Community Support Team

Re: Rankx gets recalculated

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 Frequent Visitor
Frequent Visitor

Re: Rankx gets recalculated

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)

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 286 members 3,347 guests
Please welcome our newest community members: