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.