Percent change is not correct between 2 measures

[Mudlogger]

Hi Guys,

I got a problem when I used DAX to calculate the Percent change between two measures.

I do not know why the result is not correct. The correct result should be as highlighted in green as per the picture.

This is my measure to calculate percent change :

% change from last Year =
IF (
ISBLANK ( [Sum Value year 2] ) || ISBLANK ( [Sum Value year 1] ),
BLANK (),
DIVIDE ( [Sum Value year 2] - [Sum Value year 1], [Sum Value year 1], BLANK () )
)

I would very much appreciate If you could help me with this.

Thank you in advance.

[PowerUserR]

Hi,

The only think I can think of is if the numbers have more decimals than are shown which becomes rounding errors for the calculation.
Other than that, I don't see any possible issues with the logic or calculation.

[Mudlogger]

Hi ,
I have tried that way before but it does not work.