Forum Discussion

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
6 years ago
Solved

BLANK() in DAX

Hello,   I need to feed this logic into a measure.   A B C Is Exclude blank blank blank yes blank blank 0 yes blank 0 blank yes blank 0...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    smpa01 , March 2020 release support coalesce , you can do like

     

    Switch(True()
    coalesce([A],0) =0 && coalesce([B],0)=0 && coalesce([C],0) =0 , "Exclude",
    "Include")

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

smpa01 , March 2020 release support coalesce , you can do like

 

Switch(True()
coalesce([A],0) =0 && coalesce([B],0)=0 && coalesce([C],0) =0 , "Exclude",
"Include")

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
6 years ago

amitchandak  did not have time to test out....crazy week... will come back to you after testing.