lookupvalue using calculate

[yugofukuda]

Hi,

I created the expression as below but I don't know how to insert today´s WD22 automatically (for example, today´s wd22 is 17). 
I tried to use calculate or lookupvalue but it didn´t work well.
Could you help me??
 

For Forecast =

CALCULATE(sum(sales), 'Calendar'[WD 22]=17 *I would like to put 17 automatically. )

[Greg_Deckler · Accepted solution]

@yugofukuda - Maybe:

For Forecast =
  VAR __WD22 = MAXX(FILTER('Calendar',[Date] = TODAY()),[WD 22])
RETURN
  CALCULATE(sum(sales), 'Calendar'[WD 22]=__WD22)

[yugofukuda]

@Greg_Deckler 

Thank you very much!! It worked well!!!