Forum Discussion
Multiple active relationship workaround
I use the USERELATIONSHIP expression for this without creating additional columns. Here is a link:
https://msdn.microsoft.com/en-us/library/hh230952.aspx?f=255&MSPPError=-2147217396
THanks kcantor. I actually use USERELATIONSHIP extensively but that doesn't work in my current scenario because that just switches the default relationship, I would need two active relationships to the same table at once.
I need my VendorTable to be actively connected to my DateTable whilst also actively being connected to my FactTable.
In that case, I would use PowerQuery to 1. duplicate the vendor table, and 2. reduce the vendor table down to a single vendor id so that it could be used as a lookup table. Then I would simply use the original vendor table as another fact table and bridge it to the vendor id table and the date table. Bridge the Fact table to the date table and to the vendor id table. Make sure you populate the rows using the lookup table data and the values from the fact tables.
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.Can you post a sample of your data here?