Forum Discussion

bundipapa's avatar
bundipapa
Helper I
2 years ago

Total a value ignoring TOPN filter

Hello,


I have to create a view of the TOP 5 products sold with applicable GEO and other filters/slicers (product group and similar - only using GEO in the example). My problem is with showing, what portion the TOP 5 products represent of the total revenue when the filters are applied. I need a calculation, that would adjust based on the slicers, but would ignore the TOPN filter setting and sum the revenue for all products for the given slicer setup.


For Total revnue here I have the function 

Total revenue = CALCULATE(sum(Sheet1[Revenue]),ALL(Sheet1))
If I select NA, the total revenue remains the same, although NA is only 21M of the total of 61M.

 



1 Reply

  • Hi bundipapa ,

     

    What about allexcepting GEO field so that the GEO filter will be applied to your Total revenue measure?  

    Best regards,