DAX DATEMTD Won't Calculate Properly

[Sphinx404]

I've been in countless forums looking for the solution to this problem.I'm working with a Data Model (Power Pivot), and I'm completing my measures for the current total of Defect Per UnitThe Measure for the TOTAL works just fine.The Measure for the YTD works just fine.The Measure for the MTD returns nothing (blank)I cannot get a handle on why.

Code:
Assembly PDI Defect Count:=CALCULATE([PDI Defect Count],Defects[Cause Group]="Assembly",USERELATIONSHIP(Defects[Date],'Calendar'[Date])) - initial total - WORKS

Assembly PDI Defect Count YTD:=CALCULATE([Assembly PDI Defect Count],DATESYTD('Calendar'[Date])) - Total year-to-date - WORKS and verified

Assembly PDI Defect Count MTD:=CALCULATE([Assembly PDI Defect Count],DATESMTD('Calendar'[Date])) - Does not WORK - should report "4", but reports "(blank)"
Any help would be greatly appreciated.

 

[Matt Allington]

How are you testing this? You really need a month worth of data, filter for 1 month, and put the calendar dates on rows in a pivot, then put your main measure and mtd measure into the pivot too. This will give you a clear view of what is happening. If it still doesn’t work, build some test measures to see what is happening, such as
countrows(datesmtd(cal[date]))