Hello,

I've implemented a simple tabular model using SQL Server 2012 SP1 SSDT with a date dimension that  has an active relationship with the date key in the fact table and has met the criteria for a date dimension to the best of my knowledge, i.e. no missing dates, etc.

However, when I add a calculated measure in the VS project using any time intelligence function, i.e. =CALCULATE(SUM([NewPatientTotal]),TOTALYTD(DimDate[Date])), the calculated measure only returns the value of the current member, i.e. SUM(NewPatientTotal]) without throwing an error.  This is happens for all time intelligence functions!

Are there any best practices that I've missed? I've scoured the SSAS forums to no avail.

Thanks,