Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
Solved! Go to Solution.
Hi @Anonymous ,
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.
Hi @Anonymous ,
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.
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |