Calculated measure across different data sources

[mrbuttons07]

Hello everyone!

I have a data source with multiple relationships like below.

How can I get a calculated measure that can calculate something like this.

Overall Yield = Yield (A Yield) * Yield (B Yield) * Yield (Yield C)

I have tried doing the calculate measure, but it's returning the same value for each rows.

Thanks!

[VahidDM]

Hi

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/

[mrbuttons07]

Hi @VahidDM 

My apologies! Here's the link to the power bi workbook and excel file stored in my one drive.

https://1drv.ms/f/s!AiNw1b4HnMZOgaBb0fIaKLkRaAnuEA

Many thanks for your help!