Prevent future calculations in a measure

[KristofDM]

I made a measure to calculate efficiency. It works ok but as soon as future quarters are added to the filter section of the report, the measure shows 100 efficiency (1) . Is there a way to prevent logic from being triggered on future data that is actually non-existent?
As i start the measure with 1-, the result is 1 if no data is returned.

any idea would be greatly appreciated! ps: I indeed stole the formula from an excel sheet 🙂 

testmeasure= 1-(DIVIDE(
  (SUM
   (table[xdays])
   ),
  (SUM
   (table[Durationday])
   -SUM(TABLE[OtherDay])
   )
  )
 )

[amitchandak]

@KristofDM , something like this

testmeasure= calculate(1-(DIVIDE(
(SUM
(table[xdays])
),
(SUM
(table[Durationday])
-SUM(TABLE[OtherDay])
)
)
), date[date] <today())

[Greg_Deckler · Accepted solution]

@KristofDM - 

Try something along the lines of:

testmeasure= 
VAR __measure = 
1-(DIVIDE(
  (SUM
   (table[xdays])
   ),
  (SUM
   (table[Durationday])
   -SUM(TABLE[OtherDay])
   )
  )
 )
RETURN
  IF(<some condition that identifies future>,BLANK(),__measure)

For example, the condition could be MAX('Table'[Date]) > TODAY()

[KristofDM]

thank you all for your sugestions, the VAR __measure was indeed what i was missing!

thanks @Greg_Deckler