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])     Curre...
  • 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.

Sahir_Maharaj's avatar
Sahir_Maharaj
Super 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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Sahir_Maharaj  It worked!!  Thank you so much!!