Product Ranking - Override Permissions/Filters

[Anonymous]

Hi All!  

I'm looking for some help on how to ignore a filter context while using RankX.

This is my current DAX calculation:

Rank Qty = 
RANKX(ALL('Dim ITEM'), [Total Qty])

Currently I have permissions set on my dashboard so the viewers (sales ppl) can only see their territory (Dim Customer, [territory]).  I am looking to override the permissions for this specific table visual so they are able to view overall company product ranking.  

Any ideas on how to do this?

Thank you!!

Christina

[Sahir_Maharaj · Accepted solution]

Hello @Anonymous,

1. Create a measure that calculates the total quantity without considering any filters applied to the 'Dim Customer' table.

Total Qty (All Customers) = CALCULATE([Total Qty], ALL('Dim Customer'))

2. Create a new measure using the RANKX function to calculate the overall company product ranking based on the 'Total Qty (All Customers)' measure.

Rank Qty (Overall) = RANKX(ALL('Dim ITEM'), [Total Qty (All Customers)])

3. Use the 'Rank Qty (Overall)' measure in your visual to display the overall company product ranking. Do not hesitate to let me know if you might need further assistance.

[Anonymous]

@Sahir_Maharaj  It worked!!  Thank you so much!!