sum the difference between the two measures

[georgianamha]

Hi,

When i add this measure  sum ([Sales value BGN] - [Cost value BGN]) i receive the message "Error in expression"

Both sales and cost values BGN are measures - sum (sales) and sum(cost) 

I just started in the reporting area and i have no clue why the expression is not correct

Do you have ideas?

Thank you!

[lukas_]

Hi,

Are [Sales value BGN] and [Cost value BGN] in purple and identified as main measures?

[vinieme12]

Double aggregation is not possible

Sum(sum( sales))

You can just use your actual expressions 

=Sum(Sales)-Sum(Cost) 

If you need to further aggregate the result of this, then it needs to be wrapped in Aggr()  as below 

=Sum ( Aggr ( 

Sum(Sales)-Sum(Cost) 

, Dimension1, Dimension2) )

Replace Dimension1 and Dimension2 with the fields used in your chart /table or add more separated by commas as needed based on what granularity you need to aggregate it result on

[edwin]

try separating them into two columns:
 sum ([Sales value BGN])

and sum([Cost value BGN])

and these are both numeric?

[georgianamha]

thank you!! i separated them and it worked 🙂