Creating a measure to calculate but grand total not giving me the correct value

[jeesan1234]

I have the following matrix that shows month, month week, no. of working days and I am calculating expected claims by doing (no. of working days)*(Sum of expected claims per day). The first way (Expected Claims $000) is by creating a measure which gave me the correct values, however, the grand total is wrong, instead of summing the three months subtotals, it's calculating the total using the sum of both fields. 

The second way the last row is by creating calculated column, which is giving me the correct grandtotal but not the correct values for each month week. Could someone please help/advice on how to get the values how they appear the first way and grand total how it appears using the second way?

[Ashish_Mathur · Accepted solution]

Hi,

Try this measure

Measure = SUMX(VALUES(Calendar[Month week]),[Expected claims $000])

Hope this helps.