Calculate return no value

[P-H]

Hi i'm calculating sales over month. with a year to date total column. it is working fine if there is sales for the current month but if there is no sales, it is not calculating for this month.

=CALCULATE (
    [Sum of LINETOTAL],
    FILTER (
        ALL ( Query[MonthOrder] ),
        Query[MonthOrder] <= MAX (Query[MonthOrder] )
    )
)

ex of the result if there is no sales in november

order oct---YTD OCT---order nov---ytd NOV --- order dec--- YTD DEC 

1000            5000          empty           empty   --- 1000              6000

what i want is to have 0 for order nov and 5000 for YTD Nov

[FreemanZ]

hi @P-H ,

Seems doable but also strange. Try to pose some sample data, ideally with expected result.