Shared semantic model vs local model - different results for same measure code

Hi bhalicki,

Thank you for posting your query and providing detailed information. The difference in results between using a local model (DimCalendar) and a shared semantic model (DimCalendarRemote) with the same measure could be due to several factors:

• The relationship with DimCalendarRemote might handle filtering differently due to its shared semantic model nature, potentially affecting context propagation in Direct Query mode.
• DimCalendarRemote, if not fully refreshed or synchronized, might yield different results compared to the local DimCalendar or If DimCalendarRemote uses Direct Query while the local model is imported, differences in query execution or source database behavior could impact the MAX(DateKey) calculation.
• The SELECTEDVALUE(ProjectTargets[ProjectKey]) might behave differently based on the active relationship and context in the shared model.
  
  

Here are the few troubleshooting steps you can consider:

• Verify that the relationships between ProjectTargets and both DimCalendar tables are correctly set up and active.
• Test the measure with a simple MAX(ProjectTargets[DateKey]) to isolate the issue.
• Check the Power BI Service for any refresh delays or performance issues with DimCalendarRemote.
• Check the data types and values in DateKey and ProjectKey are consistent across both models.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.