Forum Discussion

ravirayala4252's avatar
ravirayala4252
Icon for Helper I rankHelper I
3 years ago

Help me the with DAX Measure ?..

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

 

 



1 Reply

  • ravirayala4252's avatar
    ravirayala4252
    Icon for Helper I rankHelper I
    3 years ago

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