Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello all,
Currently I have a the following Dax measures
Labor Rate = SUM(cf[rate_hourly])
Labor Hours = SUM(wrhwr[act_labor_hours])
and finally
Labor Costs = [Labor Hours] * [Labor Rate]
Now when using the "Labor Costs" measure inside a table I want to have the total amount be displayed however the total amount displayed is incorrect from the rows in the table if I was to manually add them up.
Example below
These Values do NOT equal $2,029.23 hwever they do equal $521.72, how can i make sure my Labor Costs is displayed correctly.
Thanks in advance.
Solved! Go to Solution.
I think you'll want to use SUMX
Labor Cost= sumx(wrhwr, [rate_hourly]*[act_labor_hours])
I think you'll want to use SUMX
Labor Cost= sumx(wrhwr, [rate_hourly]*[act_labor_hours])
Thank you
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |