Measure Field not Calculating with Filters

[skedis]

Hi Everyone,

I have multiple tables - 1 is a calendarlookup table and another called problem. They both share a key called month_key. I have a matrix table that shows the total time ytd, for one year the value is 525600 and I expect when two years are selected the value should be 525600x2= 1051200. However, the measure remains 525600, please see screenshots below:

Total Time YTD = SELECTEDVALUE('Problem'[Total Time (Mins) YTD])

My suspcion is because of the month_key value. I pulled both month_key values from the tables into the matrix and they do not match. 

Any advice or tips would be greatly appreciated!

Thank you,

Susan

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.