Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a measure that associates the daily rate of a contract and the actual use of that contract in a month.
Solved! Go to Solution.
Hey @RPAI2812.
Try:
Rate Cost =
SUMX (
'Table 1',
'Table 1'[Day Rate] * 'Table 1'[Used Days]
)
That will go row by row and multiply the rate times the days, and then sum those values, which is correct.
Your measures are instead summing the rates, summing the days, and then multiplying those two sums together, which is incorrect.
Hey @RPAI2812.
Try:
Rate Cost =
SUMX (
'Table 1',
'Table 1'[Day Rate] * 'Table 1'[Used Days]
)
That will go row by row and multiply the rate times the days, and then sum those values, which is correct.
Your measures are instead summing the rates, summing the days, and then multiplying those two sums together, which is incorrect.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |