Forum Discussion
Error in measures between two linked tables
Hello. I have two tables. Table_1 is for scheduled work that contains an employee ID, work area number, cost center number, the date, and the amount of scheduled hours (along with others that are irr...
I have also created two other measures to separate the hours worked and the hours scheduled:
mTotalStd= CALCULATE(
SUM(
Table_1[Scheduled Hours]
),
USERELATIONSHIP(
Table_1[Identifier],Table_2[Identifier]
)
)
mTotalWorked= CALCULATE(
SUM(
Table_2[Total Work Hours]
),
USERELATIONSHIP(
Table_1[Identifier],Table_2[Identifier]
)
)
I created a table shown in the top screenshot, but the total worked hours measure is off. The screenshot on the bottom is correct and the screenshot on the top is incorrect. The bottom is using summarize whereas top table is using the calculated measures.