monthly reports in a yearly chart, help

[omar8000]

I have a bunch of monthly reports example current Employee count or current stock.

when I showed them in a chart at monthly level ( no issue)

at year level (it should show the value for December, PBI "SUM" the values which is wrong,)

I tried

    count for December = 
CALCULATE(
    SUM('data'[count]),
    'data'[Date].[Month] IN { "December" },
    ALL('data'[Date].[MonthNo])
)

at year level ( worked fine )

at month level (it should show the value for December for all months)

help 😅

[amitchandak]

@omar8000 , it better to have month column for this

like

count for December =
CALCULATE(
SUM('data'[count]),
'data'[Month] = "December"
)

or

count for December =
CALCULATE(
SUM('data'[count]),
'data'[Date].[Month] = "December" ,
ALL('data'[Date])
)