Forum Discussion
Bridge Table
Hi Earosenfeld ,
these are not bridge tables but dimension tables and therefore completely correct.
The question is, are there any master data tables in your system from which you can load the unique values for your dimension table?
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Hi,
the problem is still not solved. Removing duplicates can remove unique values as well.
For example
if two columns look like
1 a
1 b
2 c
2 d
3 e
3 f
If I highlight both no duplactes would be removed, If I highlight the one with duplicated column, unqiue values would be removed from the other.
When I want to slice two data sources by the same field, a many to many relationship does not filter correctly when there are multiple slicers in my experience. I need a many to one, and the only way I can do that is with a unique column.
I was able to accomplish this by copying the query multiple times and remove all other columns besides the one I want to filter by, then removing all duplicated values.
Although I really think there should be an easier way.... dont you?
Hi Earosenfeld ,
these are not bridge tables but dimension tables and therefore completely correct.
The question is, are there any master data tables in your system from which you can load the unique values for your dimension table?
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Ahh I see. I can load the unique values from a master data table. However I prefer not to create another data source if I don't have too. I guess this is the best way to go about it. Thank you for the clarification.