Simple calculation

[Anonymous]

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

[Anonymous · Accepted solution]

I figured out:

Increase Selceted Day YTD = IF('Shop Account Ledger'[Prior YTD Selected Day Actual Amount]=0,

                                'Shop Account Ledger'[YTD Selected Day Actual Amount],    

                               IF('Shop Account Ledger'[Prior YTD Selected Day Actual Amount]<>BLANK(),

                                 CALCULATE(('Shop Account Ledger'[YTD Selected Day Actual Amount]-'Shop Account Ledger'[Prior YTD Selected Day Actual Amount])/ABS('Shop Account Ledger'[Prior YTD Selected Day Actual Amount])),

                                  BLANK()

                                  )

                              )