Show 0 instead of Blank on specific condition

[Alicia_Anderson]

I want to force a zero to display instead of blank when a specific condition occurs.   

I have a measure that calculates points Done, which works fine:   

Effort-Done = CALCULATE(SUM('PI_Work'[Effort]), 'PI_Work','PI_Work'[State]="Done")

However, if the Sprint is less than the Current Sprint (is in the past) and it shows blank, I want it to return 0 instead.  This is my attempt but it is showing zero for all Sprints and not just those in the past.   

Effort_Done2 = VAR DoneZero = CALCULATE(SUM('PI_Work'[Effort]), 'PI_Work','PI_Work'[State]="Done", FILTER('PI_Work','PI_Work'[Sprint#]<[Current_Sprint#])) RETURN if(DoneZero=Blank(),0,DoneZero)

In my example below, the Current Sprint=5

[johnt75 · Accepted solution]

You can try

Effort done 2 =
var workDone = [Effort-Done]
return IF( SELECTEDVALUE( 'PI_Work'[Sprint#]) < [Current Sprint#], COALESCE(workDone, 0), workDone)

[Alicia_Anderson]

I get an error with that:  “Too many arguments were passed to the SELECTEDVALUE function.   The maximum argument count for the function is 2.”

[johnt75]

Typo, I was missing a ). I've edited the original post.