Line Chart: Not showing Line when Zero

Hi Anonymous ,

It caused by brackets. Try this.

Actual Cumulative Adj =
IF (
    CALCULATE (
        SUM ( 'Fact Summary'[YTD Actuals] ),
        FILTER (
            ALLSELECTED ( 'DimDate'[FIN_YR_MONTH] ),
            ISONORAFTER ( 'DimDate'[FIN_YR_MONTH], MAX ( 'DimDate'[FIN_YR_MONTH] ), DESC )
        )
    ) = 0,
    BLANK (),
    CALCULATE (
        SUM ( 'Fact Summary'[YTD Actuals] ),
        FILTER (
            ALLSELECTED ( 'DimDate'[FIN_YR_MONTH] ),
            ISONORAFTER ( 'DimDate'[FIN_YR_MONTH], MAX ( 'DimDate'[FIN_YR_MONTH] ), DESC )
        )
    )
)

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Anonymous ,

Try putting your previous formula in VAR

Actual Cumulative Adj =
VAR  ActualCumAdj =  
   CALCULATE(
       SUM('Fact Summary'[YTD Actuals]),
           FILTER(
               ALLSELECTED('DimDate'[FIN_YR_MONTH]),
               ISONORAFTER('DimDate'[FIN_YR_MONTH],         
                      MAX('DimDate'[FIN_YR_MONTH]),
                      DESC)
          )
)

RETURN 

if(  ActualCumAdj =  0, BLANK(),  ActualCumAdj)

also, the reason of the error is that you missed one ")".

You missed to close the calculate code before putting =0.

You can easily trace it if you will organise your formula with correct spaces and br

I finally had a chance to try your solution out. It works. Awesome.