Why I am getting two values for MTD

[Anonymous]

I have created the measure to calculate MTD sales.

Sales MTD = TOTALMTD([Total Sales],DimDate[Date])

With above measure I am getting the following value.

 

To check the accuracy I manually filtered the Total Sales value with FactSales Table's date column as follows and I am getting a different value.

Again I filtered manually with Date table's date column and I am getting the measure value.

Please find the attached file herewith.

sample.pbix 

[Anonymous]

@amitchandak 

Thank you for your help.

[amitchandak · Accepted solution]

@Anonymous , Date has a time stamp. I created a new date column. Joined Date of date with it. It  is working fine now.

Date1 = date(year([Date]),month([Date]),day([Date]))

Please find the link https://www.dropbox.com/s/2k8fbgz0v9ecv3z/sample%289%29.pbix?dl=0

[amitchandak]

@Anonymous , I opened the file, I am getting the Same value for both. Please let us know the parameters changed 

[Anonymous]

@amitchandak 

Try to filter total sales in visual manually with FactSales[Date] instead of DimDate[Date]