I’m currently building a dashboard that consist of data sources with multiple level of relationship. Some of the tables do not communicate with each other and do not have a relationship that I can combine.
Table Relationship
What I’m trying to achieve is to combine all 3 measures into 1 table. Ideally, the intended calculated measure I’m looking for is to get something like this.
Overall Yield = Yield A (From Table A) * Yield B (From Table B) * Yield C (From Table C).
I tried to create a relationship across the 3 tables but as they don’t talk to each other, the results being shown over is not correct and is showing one single value across day, week & month. I also tried to play around by linking the 3 tables into a master calendar table and putting the combined measure there, but it’s not working as well.
rvnd is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.