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.
So I've got a SUM function that adds up all the hours in the LineItem table. That is then filtered by a StageLabel text which is "Booked Schools" which is from another table called DealPipelineStage, here is what it looks like below:
Solved! Go to Solution.
Add a calculate before the sum
Ahhh thank you @Anonymous so calculate is needed for two seperate functions? I appreciate that.
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |