Failed to get correct total

[MFelix]

Hi @New_be ,

Try to add the following measure:

Headcount total = SUMX(VALUES(Calendar[YearMonth]) , [Headcount])

[Anonymous]

Hi @New_be ,

I checked that the original post has been resolved, are there any new problem that are still not resolved?

Best regards,
Community Support Team_ Scott Chang

[New_be]

Hi @MFelix 
Thank you for your reply.
The code didn't work since in SUMX, the expression is just [headcount]. I try replace it with MIN[headcount], but it still didn't work..

[MFelix]

Hi @New_be ,

This is a new measure that picks up the value of your previous measure it's not to replace the current measure you have.