Total a value ignoring TOPN filter

[bundipapa]

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.

[DataNinja777]

Hi @bundipapa ,

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

Best regards,