Calculations

HI,

I am sure this will be simple but very annoying.

I have cretaed a very simple example to demonstrate my frustration/inability

In the below table I have created the margin column and the total margin column using DAX formula

if you take total margin i have created a formula as follows:

Total Margin =
(SUM('Report 1'[Price]) - SUM('Report 1'[Cost])) * SUM('Report 1'[Qty])

This works when dispalying the data in a table , but the totals dont work  and similarily it wouldn't work if i wanted to display the value in a "Card" , as the context of the "product" has been lost.

In the example the total for "Total Margin" should be 2480, not 9900

I apprciate this is because i am using "Sum" in the calulation but cannot see any other way.

In other tools you can apply context by saying somthing like:

 (SUM('Report 1'[Price]) - SUM('Report 1'[Cost])) * SUM('Report 1'[Qty]) in ('Report 1'[Product])

Is there a simple way to achieve this

Thanks