Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
skedis
Helper I
Helper I

Measure Field not Calculating with Filters

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])
skedis_0-1676672063710.png

 

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

1 REPLY 1
Ashish_Mathur
Super User
Super User

Hi,

Share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.