Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sales vs Plan DIVIDE

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😅

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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])
    )

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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])
    )