How to calculate column total value by making use of measure to calculate row totals?

[Power_BI_Adapt]

Dear All,

I face the following situation:

Total column is calculated by making use of the following measure: 

CALCULATE(sum('Table 1'[Number sold]))* sum('Table 1'[Unit price])

However to get a total row of this 'Total 'column the measure is still executing its logic, resulting in a wrong total of the 'Total' column. In example: result is 234  (13 * 18), but should be 87 (sum of the values in the three rows). 

Any suggestion to fix?

Kind regards,

[AntonioM · Accepted solution]

Hi @Power_BI_Adapt ,

Please try this measure

SUMX( 'Table 1', 'Table 1'[Number sold] * 'Table 1'[Unit price] )

This will sum up one row at a time the calculation.