Combining to sums in one measure

[craig811]

Hi ,

How can I combine the following two 'Sums' in one measure:

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"))

The aim of the above is to use one measue in my Power Pivot. When I filter by account 0100042 for example I will see a Total value for GRNI and a total value for Invoice & JV. Is this possible ?

Many thanks 

[parry2k · Accepted solution]

@craig811 you can do it in two ways

- create another measure and sum these two measures in it

new measure = [first measure] + [2nd measure]

or in your measure sum those two together:

total = <your first measure calculation > + <your 2nd measure calculation>