Looking for difference between two values by filters

Hi Naveen_SV ,

I created a sample pbix file (see attachment) for you, please check whether that is what you want.

1. Create a calculated table: Table 2

Table 2 = UNION(VALUES('Table'[Cycle]),ROW("Cycle","XDifference"))

2. Create measures to get the sum amount and difference

Measure = 
 VAR _sAmountofQ1=CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[ID] = MAX ( 'Table'[ID] ) &&'Table'[Cycle]="Q1"))
 VAR _sAmountofQ2=CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[ID] = MAX ( 'Table'[ID] ) &&'Table'[Cycle]="Q2"))
 VAR _sAmountofQ3=CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[ID] = MAX ( 'Table'[ID] ) &&'Table'[Cycle]="Q3"))
 VAR _sAmountofQ4=CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[ID] = MAX ( 'Table'[ID] ) &&'Table'[Cycle]="Q4"))
return  SWITCH (
        SELECTEDVALUE ( 'Table 2'[Cycle] ),
        "XDifference",_sAmountofQ4-_sAmountofQ3-_sAmountofQ2-_sAmountofQ1,
        CALCULATE (
            SUM ( 'Table'[Amount] ),
            FILTER ( 'Table', 'Table'[ID] = MAX ( 'Table'[ID] )&&'Table'[Cycle]=MAX('Table 2'[Cycle]) )
        )
    ) 

Difference = SUMX(VALUES('Table'[ID]),[Measure]) 

3. Create a matrix visual (Rows: ID   Column: field Cycle of Table 2  Values: [Difference] )

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.