cancel
Showing results for
Did you mean:
Helper III

## Help with DAX - formula - Subtracting with filter

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.

1 ACCEPTED SOLUTION
Solution Sage

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

2 REPLIES 2
Solution Sage

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

Helper III

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 ?

Announcements