YTD and status filter not working

[eilidh3]

Hi all, 

I'm looking for some of your expertise 🙂  

Can someone shed some light on the below query:

I am looking to do a YTD calculation for all my opportunnities that are closed as won - Status = "Won".  I currently have the below DAX however no data comes back...  Does anyone have any ideas?

YTD Actual Contract Award Value =

var Calc = TOTALYTD(SUMX(FILTER(Opportunities, Opportunities[Status] = "Won"), Opportunities[Estimated Final Value]),'Date Table'[Date],ALL'Date Table'[Date], "06/30")

RETURN

If (ISBLANK(Calc), 0, Calc)

Thanks in advance 🙂

[MAwwad]

Try

YTD Actual Contract Award Value = VAR Calc = TOTALYTD( SUMX( FILTER(Opportunities, Opportunities[Status] = "Won"), Opportunities[Estimated Final Value] ), 'Date Table'[Date], ALL('Date Table'), DATE( YEAR(TODAY()), 1, 1 ) ) RETURN IF( ISBLANK(Calc), 0, Calc )

This formula calculates the YTD Actual Contract Award Value from the beginning of the current year to the current date for all the opportunities that are closed as 'Won'. Make sure to replace 'Date Table' and 'Opportunities' with the actual names of your tables.