MTD calculation values not coming correctly

[anupampandey]

Hi,

I am facing a simple problem (probably) which I am unable to resolve.

Problem is while computing the MTD values totals are matching. Below is the screen shot. 

Formula : MTD = TOTALMTD(SUM(COMM_YTD[CALC_RET_COMM]),DATESMTD('Calendar'[DateKey].[Date]))

The same method I have used earlier which is working perfectly this time I don't know what happened.

Please help me on this.

[mattbrice]

My only comment is that using both TOTALMTD and DATESMTD is redundant.  Should either do:

MTD = TOTALMTD(SUM(COMM_YTD[CALC_RET_COMM]), Calendar[Date] )  

or

MTD = CALCULATE(  SUM(COMM_YTD[CALC_RET_COMM]), DATESMTD (Calendar[Date] ) )

[anupampandey]

Hi, I have used what you suggested still not getting the desired result. Thanks, Anupam

[Phil_Seamark]

Hi @mattbrice

This PBIX file has two versions of the formula that work.

https://wgtnpowerbi-my.sharepoint.com/personal/phil_wgtnpowerbi_onmicrosoft_com/_layouts/15/guestacc...

Download and have a play to see if it helps.

Cheers,

[anupampandey]

Hi,

I am facing a simple problem (probably) which I am unable to resolve.

Problem is while computing the MTD values totals are matching. Below is the screen shot. 

Formula : MTD = TOTALMTD(SUM(COMM_YTD[CALC_RET_COMM]),DATESMTD('Calendar'[DateKey].[Date]))

The same method I have used earlier which is working perfectly this time I don't know what happened.

Please help me on this.