Forum Discussion
Calculated measure across different data sources
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!
2 Replies
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/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!
