If you are going to use Page Level filters then the it will just do as it says. What you can do instead is either : 1. Remove the page level filters and set visual level filters to each visual instead. or. 2. Create measures that are required for this visual and use the CALCULATE (Measure,ALL (. Thanks, Sean. Jul 06, 2020 · Monthly Total of Acs = CALCULATE ( SUM ( 'sheet1' [Amount] ), FILTER ( 'sheet1', 'sheet1' [Type] = "ACR" ), FILTER ( 'sheet1', 'sheet1' [Bill] = "Y" )` ) Adding these two formulas together to get the total monthly. The monthly total of ACS is where I encounter the problem. I need this to be unaffected by the slicer. Last week a client asked me to analyse a difference between the displayed total in a Power BI report and the sum of the values after exporting them to Excel. This task turned out.