Forum Discussion

vbis's avatar
vbis
Helper I
3 years ago
Solved

multiple if multiple conditions

Hello. I would need your help please with a bit complex multiple if statement with multiple conditions where I struggle with some issues.    This is my dax:   Rates = SWITCH(     TRUE(),    ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, vbis ;

    The last DAX can be simplified to and could try it.

    Rates =
IF (
    ( Clothes[Color] IN { "White", "Black" }&& [Units Sold] = "Low" )
    || Clothes[Color] = "Grey",
    SWITCH ( [Size], "Small", "5", "Medium", "10", "Large", "15" ),
    "null")


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
3 years ago

vbis , check the data in the Size column any white space or case(Upper/Lower)  issue. Overall formula looks correct

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.