Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

Blank repalce with 0 - measure

Hi All,

 

I have a measuer as:

 

Measure Deployed % = DIVIDE ('Table'[NAD],[TED])
 
For some stores I am gettig values "Blank".  I want to replace Blank by 0.     
 
NAD and TED are measure too:
 
NAD = SUM(Table[ Agents])
TED = SUM('Table'[ Total points])
 
Please advise. Thanks 
 
 
Help

4 Replies

  • Whitewater100's avatar
    Whitewater100
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Hello:

     

    You can just slightly modify your measure:

    Measure Deployed % = DIVIDE ([NAD],[TED], 0)

    Measure Deployed % = DIVIDE ([NAD],[TED], "-")

    Measure Deployed % = IF(ISBLANK(DIVIDE ([NAD],[TED]), 0, DIVIDE ([NAD],[TED], 0)

    I beleive you should be all set with the first one. You can put whatever you want at the end,"-") or ,"No Data")

    • sdhn's avatar
      sdhn
      Icon for Responsive Resident rankResponsive Resident
      4 years ago

       

      OTHER TWO DO NOT CHANGE ANYTHING. THANKS 

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        4 years ago

        sdhn , isblank should close after the first divide. Before ,0