Rankx return incorrect value randomly

[wenchi]

Hi,

We have a PBI report using SSAS live connection to Azure AS model. I am using the rankx function to rank product brand by current year vol. It's not showing the correct rank number all the time. (see picture below) There are few rows with different vol but rank the same. Sometimes it seems worinking just fine, but not all the time and I can figure it out.

Here is the measure,  

brand_rank = if(ISINSCOPE(Dim_Custom_BrandGroup[brand_family_des]),

CALCULATE(RANKX(ALL(Dim_Custom_BrandGroup[brand_family_des]),[Chain CURR Pd Vol],,DESC,Skip),Dim_Custom_BrandGroup[group_type]="brand family"),BLANK())

 

Really appreciated for all helps.

Wenchi

[Greg_Deckler]

@wenchi Those are indications of ties. Would need to know what [Chain CURR Pd Vol] is.

[wenchi]

The [Chain CURR Pd Vol] is the last column shown in the picture. it definitely shows different volume with the same rank, which is incorrect. I've validate the data against our database and it shows correct volume.

[daxer-almighty]

When you calculate the rank, you are CHANGING THE CONTEXT of the calculation: Dim_Custom_BrandGroup[group_type]="brand family". This is why your rank does not tally with what you see in the matrix. In the matrix you don't change the context.

[wenchi]

i have the same filter applied to the table visual.