Forum Discussion

I_Byte's avatar
I_Byte
New Member
2 years ago
Solved

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 table

Line graph

 

 

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

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

    • I_Byte's avatar
      I_Byte
      New Member

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