Hi all,
I am calculate a simple increase rate: (YTD amount-Prior YTD amount)/Prior YTD amount
The measure is as follow:
Increase Selceted Day YTD = IF('Shop Account Ledger'[Prior YTD amount]<>BLANK(),
IF('Shop Account Ledger'[Prior YTD amount]=0,
'Shop Account Ledger'[YTD amount],
CALCULATE(('Shop Account Ledger'[YTD amount]-'Shop Account Ledger'[Prior YTD amount])/ABS('Shop Account Ledger'[Prior YTD amount]))
),BLANK()
)
However, when the denominator(Prior YTD amount) =0, the increase rate is blank, why?

Thank you!
Branko