MTD values gives incorrect Grand Total

[Danch89]

I have a matrix with MTD calculation. In the grand total at the right hand side it always shows the latest months value rather than a sum of all columns?

Is it possible to show the Total as total of columns when using MTD calculation?

Calculation is  =  CALCULATE('Measures Table'[Sales Budget],DATESMTD('Date'[Date]))

[amitchandak · Accepted solution]

@Danch89 , MTD usually show last month MTD in total

in this case, you can use [Sales Budget]

Or try a measure like

sumx(values('Date'[Month Year]) , CALCULATE('Measures Table'[Sales Budget],DATESMTD('Date'[Date])))