Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to work with blank value?

I have 3 tables 1,2,3 And want to use Power BI to show as expectation. But I don know how to do ? Anyone can help me plz?      
blank
DAX
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Try like

    Switch(True() ,
    isblank(Sum(Table2[plan])) && isblank(Sum(Table3[Actual])), blank(),
    divide(Sum(Table3[Actual]),Sum(Table2[plan]))+0
    )

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

Anonymous , Try like

Switch(True() ,
isblank(Sum(Table2[plan])) && isblank(Sum(Table3[Actual])), blank(),
divide(Sum(Table3[Actual]),Sum(Table2[plan]))+0
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak 

     

    Supper! You saved my life!😍