Add Variance in dashboard

[Anonymous]

[Ashish_Mathur]

Hi,

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

[amitchandak]

@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

[Anonymous]

@amitchandak I have tried the measure above. Variance didn't work. Can you please have a look for me ? 

Power BI dashboard

Source of data