Forum Discussion

rogerdea's avatar
rogerdea
Icon for Helper IV rankHelper IV
5 years ago
Solved

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...
Need Help
  • themistoklis's avatar
    themistoklis
    5 years ago

    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
themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
5 years ago

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