Forum Discussion
Dimis_e
7 years agoRegular Visitor
Multiple Relationships Between Tables
Hello, I am pretty new in power bi with some knowledge from here and there and a lot of google search... My issue is this: I have two tables (one with actuals and one with targets) both with ...
- 7 years ago
Hi Dimis_e
you need to create a model like the below. The top dimension table will filter both sales and actuals
LivioLanzo
7 years agoSolution Sage
Hi Dimis_e
it depends if this column logically belongs to the dimension we have created previously or not.
what does it look like?
Dimis_e
7 years agoRegular Visitor
For the third connection I need to have for every country 4 parameters: Asset, People, Process and Technology, so this would look like Africa - Algeria - Asset Africa - Algeria - People Africa - Algeria - Process Africa - Algeria - Technology
- LivioLanzo7 years agoSolution Sage
- Dimis_e7 years agoRegular Visitor
Here is an example
- LivioLanzo7 years agoSolution Sage