Measure showing blank when should show 0

[hhammeren]

I have this measure: 

Avg Days to Pay Final = IF(CALCULATE([Avg Days to Pay], 'Date'[Year]=2017)=BLANK(), CALCULATE([Avg Days to Pay], 'Date'[Year]=2016), [Avg Days to Pay]) 

The problem is for a number in 2017 that comes out ot be 0 that should be 0 is comung up blank because the 2016 number is coming through. If I want it to only show the 2016 data when the 2017 is BLANK what am I doing wrong?

[Anonymous]

Hi @hhammeren,

You can add "+0" at the tail of your formula to replace blank value to zero.

In addition, if you use matrix visual and the blank value is caused by not exist records, you can't direct replace it to zero.(the records not real contains in your table, it displayed by summary function of matrix)

Regards,

Xiaoxin Sheng

[TheOckieMofo]

I think if you wrap your if condition in ISBLANK() instead of = blank() it might work. Try that.

[vanessafvg]

I usually say if(isblank(measure),0, measure )

that should solve it @hhammeren