Forum Discussion
Retun 0 not blank when using variables
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
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
1 Reply
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