If error return 0 in measure

[profilewatercli]

hi all, i created a measure for my stacked line chart but i currently facing some issue in using the measure function. So i have a measure that looks like this 

Amount = 
DIVIDE(
	SUM('table1'[FP]),
	SUM('table1'[Amount])
)

however, since some of the year are 0 for both FP and Amount field, the stacked chart churns out as screenshot below.

may i know if how should i rewrite the measure formula to make the stacked line chart link from 14 to 16? as i know that 0 divided by 0 is error.

Thanks! 

[PijushRoy · Accepted solution]

Hi @profilewatercli 

Please use

Amount = 
DIVIDE(
	SUM('table1'[FP]),
	SUM('table1'[Amount]),
0
)

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin