Forum Discussion

marvelbites06's avatar
marvelbites06
Frequent Visitor
2 years ago
Solved

DAX for multiple Conditions: IF and OR

I have a situation Where I want to use 4 conditions for Calculate the Sum of the Qty. Below is the base DAX That I am using but i have the put filter on the Page to get the results. Now I want to com...
Need Help
Tips and Tricks
  • marvelbites06's avatar
    marvelbites06
    2 years ago

    Got the Solution. Thank You. Filtering Issue. 

     

    Blocked =
        VAR Result =
            SUMX(
                MATERIAL_MOVEMENT_FACT_G_VW,
                VAR PosQty =
                    IF(
                        AND(
                            MATERIAL_MOVEMENT[QuantityNum] > 0,
                            OR(
                                MATERIAL_MOVEMENT[MovementTypeCd] = "344",
                                OR(
                                    MATERIAL_MOVEMENT[MovementTypeCd] = "996",
                                    MATERIAL_MOVEMENT[MovementTypeCd] = "Z44"
                                )
                            )
                        ),
                        MATERIAL_MOVEMENT[QuantityNum],
                        0
                    )
                RETURN PosQty
            )
        RETURN Result
Kaviraj11's avatar
Kaviraj11
Icon for Solution Sage rankSolution Sage
2 years ago

Did you try with SWITCH?

 

EXAMPLE:

= SWITCH (
TRUE(),
[Reorder Point] > [Safety Stock Level], "Good: Safety stock level exceeded",
[Reorder Point] = [Safety Stock Level], "Minimal: Safety stock level met",
[Reorder Point] < [Safety Stock Level], "At risk: Safety stock level not met",
ISBLANK ( [Reorder Point] ), "Incomplete: Reorder point not set",
ISBLANK ( [Safety Stock Level] ), "Incomplete: Safety stock level not set",
"Unknown"
)

 

SWITCH function (DAX) - DAX | Microsoft Learn

marvelbites06's avatar
marvelbites06
Frequent Visitor
2 years ago

Yes, Tried SWITCH but still the results are same.

Blocked =
    VAR Result =
        SUMX(
            MATERIAL_MOVEMENT_FACT_G_VW,
            VAR PosQty =
                SWITCH(
                    TRUE(),
                    MATERIAL_MOVEMENT_FACT_G_VW[QuantityNum] > 0 &&
                    MATERIAL_MOVEMENT_FACT_G_VW[MovementTypeCd] = "344",
                    MATERIAL_MOVEMENT_FACT_G_VW[MovementTypeCd] = "996",
                    MATERIAL_MOVEMENT_FACT_G_VW[MovementTypeCd] = "Z44",
                    MATERIAL_MOVEMENT_FACT_G_VW[QuantityNum],
                    BLANK()
                )
            RETURN PosQty
        )
    RETURN Result