RankX struggling to interact in a single report page

[Anonymous]

Hi all,

Having some issues with RankX that I think is caused by the data model as opposed to the formula "Pols ADV % Rank = RANKX(ALL('Pols Outcome and Inception'[Main Account Name + FCA]),CALCULATE([ADV%]))".

In the "Policy FLT" sheet, my RankX formula works perfectly. Whenever I select any of the slicers or the individual entries within the matrix (indicated by the blue X) it will display the "Pols ADV% Rank" unfiltered, but will show me only the filtered "Main Account Name + FCA" entires (red circle). You can see in photo 1 and photo 2 how this starts and should look if the formula works correctly!

For some reason this breaks when I use the exact same formula in the "Product FLT" sheet, as instaeed of displaying the unfiltered rank in the "Product Code + Scheme fin" maxtrix, it re-ranks the list based on the filter. (See photo 3 and photo 4).  

I've tried couuntless ways of getting round this to no avail. It seems only the "Product scheme slicer" works in photo 3 and 4 but the main accouunt name slicer doesn't, so I think it must be a model issue somewhere? If someone could take a look at my report in the link below and let me know where I've gone wrong that'd be fantastic!

(a copy containing no sensitive info is here https://www.dropbox.com/s/52xs398a2v1wa0h/File%20Mar%2011%2C%2011%2020%2014%20AM?dl=0 )

Kind regards,

Jordan 

[Anonymous · Accepted solution]

Appears the calculation is created correctly, and that the problem lies within the data itself!

[v-alq-msft]

Hi, @Anonymous 

Based on your description, I'd like to suggest you try the following measure.

Pols ADV % Rank = 
RANKX(ALLSELECTED('Pols Outcome and Inception'),CALCULATE([ADV%]))

Best Regards

Allan

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