Forum Discussion

maracles's avatar
maracles
Icon for Resolver II rankResolver II
10 years ago

Multiple active relationship workaround

Is there a work around for Power BI not support multiple active relationships? I have a situation where my Fact Table is related to another table in a one-to-many relationship. The fact table bein...
Need Help
maracles's avatar
maracles
Icon for Resolver II rankResolver II
10 years ago

I've rearranged ym Data Model in the manner that you suggest however now I can't get any relationships to work. For example when I list the Lookup table ID and then try and bring in any columns from either table it simply lists every row with the same value.

Think my brain is fried for tonight so will have to try tomorro! Thanks. 

kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
10 years ago

Can you post a sample of your data here?