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 IIGet rid of the relationship from dimCustomerMeter to factSummaryTicket. eticketOperatorID in dimCustomerMeter to dimCustomers can then be made, but make it bi-directional if you plan on using anything in dimCustomerMeter as as a filter/slicer.