Help me the with DAX Measure ?..

[ravirayala4252]

Dear PBI Experts
Good Morning 
I have a Situation Below, please help me with the Solution.
Thanks in advance!..

[ravirayala4252]

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()

    )