Retun 0 not blank when using variables

[rogerdea]

I am trying to ensure i return a 0 and not blank in this field.  I am unable to get it to work so far, my code is as follows.  any help greatly appreciated:

Weekly Target LB = 
        VAR Weeks =
            round(DATEDIFF(TODAY(),ENDOFYEAR('Date table'[Date],"31/01/2021"),DAY)/7,0)
        VAR OS = 
            COUNTROWS(FILTER('Metadata','Metadata'[Status] <> "RecordComplete"))
      
        RETURN
        OS / Weeks

[themistoklis · Accepted solution]

@rogerdea 

Try any of the 3 options below:

1. Measure = CALCULATE ( SUM (table[column] ), FILTER (... ) ) + 0 (Add Zero at the end of the formula)

2. Measure = IF ( ISBLANK([Amount]), 0, [Amount])

3. Measure = IF (CALCULATE ( SUM ( Expenses[Actual] ) ) = BLANK (), 0, CALCULATE ( SUM ( Expenses[Actual] ) ) )

In your case try first the following:

RETURN
        (OS / Weeks) + 0