% Change showing 0% if a value is 0

[Anonymous]

I have the following measure that calculates % change 

% Vic Change =

VAR _Num =

CALCULATE (

IF (ISBLANK(DISTINCTCOUNT('Table'[ID])), 0, (DISTINCTCOUNT('Table'[ID]))),

FILTER(ALL('Date'[FY]),

'Date'[FY] = MAX('Date'[FY])))

VAR _Den =

CALCULATE (

IF (ISBLANK(DISTINCTCOUNT('Table'[ID])), 0, (DISTINCTCOUNT('Table'[ID]))),

FILTER(ALL('Date'[FY]),

'Date'[FY] = MAX('Date'[FY])-1))

VAR _PercentChange = IFERROR((_Num-_Den)/_Den ,0)

RETURN

_PercentChange

It works perfectly 99% of the time, however if the previous year that is being compared to (defined in variable "_Den") has a value of 0, then no matter what the current year is (variable "_Num"), the % change shows a value 0f 0%. For example, the following should say an increase of 200%, not 0%:

As mentioned works fine other than this, and even works fine for if both values are 0, as expected 0% change is shown:

It also works fine if the current year value is 0 and previous year is greater than 0.
Any help appreciated.

[VIJAYKUMART]

replace the VAR _PercentChange  with the below formula 

VAR _PercentChange   = DIVIDE((_Num-_Den),_Den)

hope this helps

[Anonymous]

Hi @VIJAYKUMART Thanks for the reply. This doesn't seem to work, it brings back a (blank) value instead.