Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
@I_Byte What you are showing in your line graph is all of Q1 2023 which is indeed 622 (Jan, Feb, Mar)
@I_Byte What you are showing in your line graph is all of Q1 2023 which is indeed 622 (Jan, Feb, Mar)
Well that is slightly embarassing...guess another pair of eyes is all I needed. 😁
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |