DAX-Issues in creating a calculated measure across 3 different data sources

[mrbuttons]

Hello everyone!

I have a data source that consist of multiple tables with different relationship. I'm trying to achieve a calculated measure that uses 3 other measures that comes from different tables.

I'm trying to create a measure that looks like this,

Overall Yield = 'A Yield'[Yield A Formula] *'B Yield'[Yield B Formula] *'C Yield'[Yield C Formula]

However, this formula is not working despite me already creating a relationship on the entire data model itself. Here's the link to the power bi workbook and excel file stored in my one drive.

Microsoft OneDrive

Thank you very much for your help and support!

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Issues in creating a calculated measure across 3 different data sources - OzGrid Free Excel/VBA Help Forum

https://www.mrexcel.com/board/threads/dax-issues-in-creating-a-calculated-measure-across-3-different-data-sources.1260616/ Hello everyone! I have a data source that consist of multiple tables with different relationship. I'm trying to achieve a…

forum.ozgrid.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[mrbuttons]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Issues in creating a calculated measure across 3 different data sources - OzGrid Free Excel/VBA Help Forum

https://www.mrexcel.com/board/threads/dax-issues-in-creating-a-calculated-measure-across-3-different-data-sources.1260616/ Hello everyone! I have a data source that consist of multiple tables with different relationship. I'm trying to achieve a…

forum.ozgrid.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Hi Roy,

Thanks for pointing out! I have edited the post to include the link of the other post.

Thanks again!

 

[mrbuttons]

Cross post link: Issues in creating a calculated measure across 3 different data sources - OzGrid Free Excel/VBA Help Forum