Add Variance in dashboard

Anonymous , You can replace total with variance using isinscope

 

New measure =

 

if(Not(isinscope (Table[period])) && Not(isinscope (Table[Status])) , Calculate(SUm(Table[Amount]), filter(Table, Table[Status] ="Actual")) -Calculate(SUm(Table[Amount]), filter(Table, Table[Status] ="Budget")) , Sum(Table[Amount]))

 

How to Switch Subtotal and Grand Total in Power BI | Power BI Tutorials| isinscope: https://youtu.be/smhIPw3OkKA

Hi,

Please seem my response to a similar question here - Re: Showing calculated column in matrix while show... - Microsoft Fabric Community