% change not working if previous year 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.

[amitchandak]

@Anonymous , Try like

measure =
_Num = CALCULATE ( (DISTINCTCOUNT('Table'[ID])),
FILTER(ALL('Date'[FY]),
'Date'[FY] = MAX('Date'[FY])))
VAR _Den =
CALCULATE (
DISTINCTCOUNT('Table'[ID]),
FILTER(ALL('Date'[FY]),
'Date'[FY] = MAX('Date'[FY])-1))

VAR _PercentChange = divide(_Num-_Den),_Den ,0)
RETURN
_PercentChange

[Anonymous]

Hi @amitchandak , this measure just returns a blank % change. (I had to add another open bracket after the divide fucntion to get the measure to work, but yes still returns blank value)