Multiply Values from 2 different columns with empty values and reflect accurate Total SUM

[datatbl123]

Hi,

I have 2 diffrent tables I am working with. Table1 has recorded employee work time (Hours) which is a measure and I have antoher table with the same employee names with their corresponding hourly rates. The issue that I have is that the total Actual amount is not showing the rate multiplied by the amount of hours worked correctly, it's much too high. If no hours worked the amout of Actual shows empty which it should but the total Actual shouldn't be 39.50*1,015 but more the sum of 3,879, 1,425 and 2,200 which it should be 7,504 instead of the $40,093 it is showing. Anyone can help resolve this issue?

[Whitewater100 · Accepted solution]

Hi:

I'm sorry one ) after [usersname],  and just one at the end ).

The reason we are looking at username is because that is what looks to be in your first column. It should be the value of the field what is under your image of TOTAL. It is blacked out so I'm guessing that's what measure is. Maybe [Employee Name]?

[datatbl123]

That worked! Thank you.

[Whitewater100]

Hello:

Can you try

  SUMX(VALUES(Employee[Name], [put name of your measure totaling the wages here]))

[datatbl123]

I'm getting the following error: