Forum Discussion

ATREZISE's avatar
ATREZISE
Icon for Helper I rankHelper I
7 years ago
Solved

Display Blank as Zero

Hi All    There appears to be lots of posts about this with the simplest way just to add 0 to a measure...   i.e. measure = SUM(totals[revenue]) + 0   However adding 0 seems to discard any filt...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi ATREZISE 

    Create a measure

    Measure 4 =
IF (
    CALCULATE (
        SUM ( 'Table 4'[value] ),
        ALLEXCEPT ( 'Table 4', 'Table 4'[emp], 'Table 4'[project] )
    )
        = BLANK (),
    BLANK (),
    SUM ( 'Table 4'[value] ) + 0
)

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi ATREZISE 

Create a measure

Measure 4 =
IF (
    CALCULATE (
        SUM ( 'Table 4'[value] ),
        ALLEXCEPT ( 'Table 4', 'Table 4'[emp], 'Table 4'[project] )
    )
        = BLANK (),
    BLANK (),
    SUM ( 'Table 4'[value] ) + 0
)

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.