Show Blanks as Zero values

[Anonymous]

Hi Experts

i am sure this question has been asked a thousand time.... but cannot get this formula to show the blank cells as Zero..

Fees =
CALCULATE (
SUM(Data[ApplesFee]),
FILTER (Data,Data[Apples]="true"))

[D_Eichenberger · Accepted solution]

Just add a +0 to your formula:

That should do the trick

SUM(Data[ApplesFee])+0,

[Anonymous]

Many Thanks D_Eichenberger.....excellent feedback and good tip.