Forum Discussion
Solved
Best Way to Build Visual Using Fields from Two Separate Fact-Dimension-Custom Chains?
Hi everyone, I need help creating a visual in Power BI that combines data from 4 tables. Fact A → many-to-one → Dim A → one-to-many → Custom table A Fact A → many-to-one → Dim B → one-to-many ...
Hi,
If I'm in your situation I would create a bridge table to have detailed row-level combinations.
Creating a bridge table is also simpler than other approaches. You just need to use below DAX in a new table function to have all combinations from both tables and build your relationship from there.
BridgeTable =
SUMMARIZE(
FactA,
DimA[KeyColumn],
DimB[KeyColumn]
)
Hi,
If I'm in your situation I would create a bridge table to have detailed row-level combinations.
Creating a bridge table is also simpler than other approaches. You just need to use below DAX in a new table function to have all combinations from both tables and build your relationship from there.
BridgeTable =
SUMMARIZE(
FactA,
DimA[KeyColumn],
DimB[KeyColumn]
)