How do I get RANKX to work on filtered data source where same product appears on multiple rows?
In this Excel example, the data loads easily into a pivot table for the desired result.
As you can see, Banana ranked #2 in the WEST, but #3 in the EAST.
What am I missing in my RANKX calculated measure?
I want to be able to filter on different Time Period, different Geography, different Brands and rank to change based on slicer/filtering. Thanks.
Solved! Go to Solution.
THANK YOU! Both of your options work, but option 1 is my desired result.
I am going to use:
$ RANK = RANKX(ALLSELECTED(ItemRANK), CALCULATE(SUM(ItemRANK[Dol$ Sales])), ,DESC)
The fix was to remove [Product] from ALLSELECTED. Thanks @tarmerj1 and @FreemanZ, much appreciated.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.