Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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.

  • Anonymous's avatar
    Anonymous
    7 years ago

    I think you'll want to use SUMX

     

    Labor Cost= sumx(wrhwr, [rate_hourly]*[act_labor_hours])

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    I think you'll want to use SUMX

     

    Labor Cost= sumx(wrhwr, [rate_hourly]*[act_labor_hours])

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you