Don't want to cound blank value

[colourfullife]

Hi, 

i have this code

CSU SP_Constractual final =

VAR _End = CALCULATE ( MAX ( 'Data - CSU SP PO'[CONTRACTUAL_DELIVERY_DATE] ), ALL ( 'calendar' ))

RETURN

    IF (

        _End < MIN ( 'calendar'[Date] ),

        BLANK (),

CALCULATE(

    Sum('Data - CSU SP PO'[PO_LINE_QUANTITY]), USERELATIONSHIP('Data - CSU SP PO'[CONTRACTUAL_DELIVERY_DATE],'calendar'[Date]),

    FILTER(

        ALLSELECTED('calendar'[Date]),

        ('calendar'[Date] <= MAX('calendar'[Date])))))

can you tell me this code counts blank as value?

if so can you let me know how not to?

[Icey]

Hi @colourfullife ,

Try to filter the x axis column as "is not blank" in "Filters in this visual" field.

Best Regards,

Icey

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

[amitchandak]

@colourfullife , You are doing some. So the count of blank Does not arise.

You are seeing blank because there are dates missing in the date of the calendar but those are available in CONTRACTUAL_DELIVERY_DATE

Check out for the missing dates and try to add them to the calendar . This the case when the axis it the date column from the calendar table

[colourfullife]

Hi@amitchandak 

You are right. that is the reason. Is there any way sum up the values if there are dates?

I just don't want to show blank values in my graph.

thanks,

CL

[Greg_Deckler]

@colourfullife What is generating that 434 number at the bottom of your graph? Might have to share sample data.