Help with DAX - formula - Subtracting with filter

[craig811]

Hi ,

I cannot get my Measure to work 😞

I need to do the folllowing:

I want to SUM values : [GRNI DR] and [GRNI CR]

and subtract [GRNI CR] from [GRNI DR] 

for example: = =SUM([GRNI DR]) - SUM([GRNI CR])

and then filter by Account code in Table: All_Data_For_Pivot

I can't work out how to get the filter to work with the SUM.

Thank you in advance 

[TeigeGao · Accepted solution]

HI @craig811 ,

In this scenario, we can use CALCULATE() and FILTER() function like below:

measure = CALCULATE(SUM([GRNI DR]) - SUM([GRNI CR]), FILTER(ALL_Data_For_Pivot, [Account code] = ""))

Best Regards,

Teige

[craig811]

Great thank you ,

Can I combine 

=CALCULATE(SUM([Invoice & JV DR]) - SUM([Invoice & JV CR]), FILTER(ALL_Data_For_Pivot, [Account code] = "0100042"))

 and 

=CALCULATE(SUM([GRNI DR]) - SUM([GRNI CR]), FILTER(ALL_Data_For_Pivot, [Account code] = "0100042"))

Into one measure ?