topic Product Ranking - Override Permissions/Filters in DAX Commands and Tips

Product Ranking - Override Permissions/Filters

Anonymous — Thu, 22 Jun 2023 16:31:49 GMT

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

Re: Product Ranking - Override Permissions/Filters

Sahir_Maharaj — Fri, 23 Jun 2023 20:46:47 GMT

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.

Re: Product Ranking - Override Permissions/Filters

Anonymous — Thu, 13 Jul 2023 20:17:52 GMT

Sahir_Maharaj It worked!! Thank you so much!!