Reply
MFelix
Super User
Super User

Re: Failed to get correct total

Hi @New_be ,

 

Try to add the following measure:

 

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

Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



3 REPLIES 3
v-tianyich-msft
Community Support
Community Support

Syndicated - Outbound

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
Helper V
Helper V

Syndicated - Outbound

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

Syndicated - Outbound

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)