How to add additional filter condition to a measure

[Alicia_Anderson]

Someone helped me with this measure which will force a value of 0 for a Sprint.   However, I need to include an additional filter condition that ignores this logic if the Team is "No Team".  How would I do that?  Team is in the Teams table:  'Teams'[Team]

Effort-Done_0 = VAR DoneZero = [Effort-Done]

return IF( SELECTEDVALUE( 'PI_Work'[Sprint#]) < [Current_Sprint#], COALESCE(DoneZero, 0), DoneZero) 

[amitchandak · Accepted solution]

@Alicia_Anderson , Try like

Effort-Done_0 = VAR DoneZero = [Effort-Done]
return
if( max('PI_Work'[Team]) = "No Team", blank(), IF( SELECTEDVALUE( 'PI_Work'[Sprint#]) < [Current_Sprint#], COALESCE(DoneZero, 0), DoneZero) )