Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 @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.
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.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |