Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Help with ranking that ignores slicers

I have am attempting to build a report that ranks Stores, and shows that Stores ranks of certain Products vs all other Stores. My data is Sales by Product, by Store, by week. 


Now I have been able to create a measure which provides a ranking that works when using a table visual.

Rank = RANKX(ALL(Data[Store]),CALCULATE(sum(Data[Sales])))
However I would like to use slicers to refine my report page down to a single Store at a time. However when I do this the ranking is always 1. I cannot work out a way so the ranking is still based on all Stores.
I have looked at previous problems on this forum like this but cannot seem to adapt their answers to fit my data / needs.
Many thanks in advance for any help!
Community Support
Community Support

Re: Help with ranking that ignores slicers

HI, @NickoSmithio 

Sample data and expected output would help tremendously. 

For rankx measure problem, please share some simple sample data and the expected output in different scenario.


Best Regards,



Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User IV
Super User IV

Re: Help with ranking that ignores slicers


Please share the link from where i can download your PBI file.

Ashish Mathur

Helpful resources

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors