Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
I_Byte
New Member

New Measure is not summing as expected

New to Power BI so I am having some difficulty figuring this rudimentary problem out. I've got a simple table that contains numerical data reflecting number of staff broken down by employee position by month. I am attempting to create a New Measure to add our "DSP" and "Sr DSP" positions (to create an aggregate count for a line graph), however the measure is not adding correctly. For example, (see reference pic below) I expect the forumla to be returning a total of 204 for row 3 (186+18), when instead it is returning 622. Screenshots include the data table with the SUMX formula and line graph that is currently being spit out with the new measure toggled. 

 

 Data tableData table

Line graphLine graph

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@I_Byte What you are showing in your line graph is all of Q1 2023 which is indeed 622 (Jan, Feb, Mar)


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

@I_Byte What you are showing in your line graph is all of Q1 2023 which is indeed 622 (Jan, Feb, Mar)


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Well that is slightly embarassing...guess another pair of eyes is all I needed. 😁

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.