Sales vs Plan DIVIDE

[Anonymous]

Hello,

I would like to get an advice about DAX.

I created a following DAX.

DIVIDE([Sales YTD],[Plan YTD])

but I some data there is no plan or sales and get empty data with above DAX.

1. I would like to get zero when there is "no sales".
2. would like to get 100 when there is "no plan" but had sales.

   Please😅

[amitchandak · Accepted solution]

@Anonymous , Try like

Switch(true(),
isblank([Sales YTD]) && isblank([Plan YTD]), blank(),
isblank([Sales YTD]), 0,
isblank([Plan YTD]) , 100,
DIVIDE([Sales YTD],[Plan YTD])
)

[Anonymous]

@amitchandak 

Thank you!!! This worked perfectly!