Ratio with vlaue 0

[GDCPAI]

Hi everyone!

I have created a measure to calculate a ratio, syntax:  Ratio = DIVIDE([Value 1] , [Value 2],0)

Then I created a visual adding the years of my model and this measure.

It works fine for the years that have values. The problem is that it ommites the ones that have no values.

I need to fix this measure in order to also calculate 0 for the years that have no values, so I can add it to a timeline that shows the evolution keeping the 0 values in the visual.

Please help!

Thanks!

[Anonymous · Accepted solution]

DIVIDE(0 + [Value 1], [Value 2], 0)

[GDCPAI]

Brilliant! 

Thanks a lot!