topic Re: Re: Failed to get correct total in DAX Commands and Tips

Re: Failed to get correct total

MFelix — Wed, 10 Jul 2024 09:17:12 GMT

Try to add the following measure:

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

Re: Re: Failed to get correct total

New_be — Wed, 10 Jul 2024 09:30:48 GMT

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..

Re: Re: Failed to get correct total

MFelix — Wed, 10 Jul 2024 09:44:20 GMT

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.

Re: Re: Failed to get correct total

Anonymous — Thu, 11 Jul 2024 02:51:35 GMT

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