Solved: How to work with blank value?

Anonymous · ‎10-09-2020

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?

amitchandak · ‎10-09-2020

@Anonymous , Try like

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

amitchandak · ‎10-09-2020

@Anonymous , Try like

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube