Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Product Ranking - Override Permissions/Filters

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's avatar
    Sahir_Maharaj
    3 years ago

    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.

2 Replies

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Icon for Super User rankSuper User
    3 years ago

    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.