Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Appears the calculation is created correctly, and that the problem lies within the data itself!
Appears the calculation is created correctly, and that the problem lies within the data itself!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |