what am I doing wrong? Calculate(sum) DAX

[Anonymous]

I want to calculate the sum of two columns were the state of 'inprogess' is subtracted from 'done'

[deevaker]

Hi @Anonymous,

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/

[PabloDeheza · Accepted solution]

Hi @Anonymous !
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!

[Anonymous]

Done shows as a negative value.. but I think we are on the right track! Maybe I'll separate the math