Forum Discussion
bundipapa
2 years agoHelper I
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.
If I select NA, the total revenue remains the same, although NA is only 21M of the total of 61M.
1 Reply
- DataNinja777Super User
Hi bundipapa ,
What about allexcepting GEO field so that the GEO filter will be applied to your Total revenue measure?
Best regards,