Forum Discussion
Anonymous
7 years agoNot applicable
Labor Costs Dax [issue]
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.
- Anonymous7 years ago
I think you'll want to use SUMX
Labor Cost= sumx(wrhwr, [rate_hourly]*[act_labor_hours])
2 Replies
- AnonymousNot applicable
I think you'll want to use SUMX
Labor Cost= sumx(wrhwr, [rate_hourly]*[act_labor_hours])
- AnonymousNot applicable
Thank you