Forum Discussion
Power BI data model design relationships - direct active relationship would introduce ambiguity
Can anyone offer some modeling & relationship advise in Power BI? I have two Customer tables at different grains that I am trying to relate to a Customer rollup group (`'dimCustomers'`). The ...
Erokor
Resolver II
Resolver IIMuch agreed on this one Paul - I simply noticed a quick win and attributed it as such since Brian was already stating he was using the dim table for slicing.
PaulDBrown
Community Champion
Community ChampionI still think it's wiser to create a separate Dim customer table.
FWIW, I have never used a bi-directional relationship on one-to-many relationships.
In the specific instances where I need a fact table to filter a dim table, I use the function RELATEDTABLE. Here is one example:
https://community.powerbi.com/t5/Desktop/Help-Needed-w-Data-Model/m-p/1655298#M662710