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,
is the table you've shown a dimension or a fact table. Could you show both the dimension and fact?
Dimis_e
7 years agoRegular Visitor
The table is coming from a sharepoint list, so i guess it is a fact table