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.
I want to calculate the sum of two columns were the state of 'inprogess' is subtracted from 'done'
Solved! Go to Solution.
Hi @singleton2787 !
Your calculation should be like this:
Story Points Start =
CALCULATE(
SUM( Burndown[StoryPoint] ),
Burndown[State] = "InProgress"
)
- CALCULATE(
SUM( Burndown[StoryPoint] ),
Burndown[State] = "Done"
)
Let me know if that helps!
Hi @singleton2787,
in the filter context, you can't get "In Progress" and "Done" status at the same time. You should calculate both separately and then subtract
Story Points Start =
Var a = CALCULATE(SUM( Burndown[StoryPoint] ),Burndown[State] = "InProgress")
Var b = CALCULATE(SUM( Burndown[StoryPoint] ),Burndown[State] = "Done")
return
a-b
Thanks,
Deevaker Goel
+91-9711975011
deevaker@hotmail.com
https://www.linkedin.com/in/deevakerg/
Hi @singleton2787 !
Your calculation should be like this:
Story Points Start =
CALCULATE(
SUM( Burndown[StoryPoint] ),
Burndown[State] = "InProgress"
)
- CALCULATE(
SUM( Burndown[StoryPoint] ),
Burndown[State] = "Done"
)
Let me know if that helps!
Done shows as a negative value.. but I think we are on the right track! Maybe I'll separate the math
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |