Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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]?
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]?
That worked! Thank you.
Hello:
Can you try
SUMX(VALUES(Employee[Name], [put name of your measure totaling the wages here]))
I'm getting the following error:
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
46 | |
44 | |
28 | |
22 |