Hello All
For the above situation i used the following measure to calculate actual Hourr. But results are incorrect, by taking this as a referance any help can i get.
Combined Actual Hours Measure =
VAR MatchingWorkOrders =
INTERSECT(
VALUES('Firm Hours'[WO] ),
VALUES(sapexport_2022[Order #])
)
VAR MatchingMaterialIDs =
CALCULATETABLE(
VALUES('Firm Hours'[Material ID]),
NOT sapexport_2022[Order #] IN VALUES('Firm Hours'[WO]),
'Firm Hours'[Material ID] IN VALUES(sapexport_2022[Material ID])
)
RETURN
SWITCH(MAX('Firm Hours'[Category]),
"Firm", CALCULATE(SUM(sapexport_2022[Total Run Time]), sapexport_2022[Order #] IN MatchingWorkOrders),
"Firm Plan", CALCULATE(SUM(sapexport_2022[Total Run Time]), sapexport_2022[Material ID] IN MatchingMaterialIDs),
"Planned", CALCULATE(SUM(sapexport_2022[Total Run Time]), NOT sapexport_2022[Material ID] IN MatchingMaterialIDs),
BLANK()
)
