One-to-Many Relationships - The Whiteboard #08

[@brunocarvalho3229]

This channel is pure gold

[@spilledgraphics]

CRISP explanation Marco, grazie mille!

[@matsrosenqvist]

Thank you for a very informative video on One-to-Many Relationships.

[@project365]

Informative video. This further clarifies why 1-to-* many relationships between intra-source tables generates left outer join from the many side to the one side generating unknown member (blank value) for values that is that not present in the one side of the relationship.

[@bobaiyakubu5910]

Interesting

[@williamarthur4801]

Is there a way of dealing with the blank row (apart from removing via manual filter) caused by items on the many side not being on the one side? If so I shall look forward to it. Not a terrible problem when you know what the cause is but visually annoying. Enjoying the series and the cross highlight which I'm still experimenting wiht.

[@SQLBI]

Create the missing data on the one-side! Other systems simply don't load the data. Power BI is more tolerant, but you get the blank for that.

[@Wzxxx]

It seems simple but i still don’t understand one thing. Even if there is no filter propagation when i combine two colums from tables on the one side in a matrix it shows me the existing combinations when i use a measure. So it seems like the data is still filtered correctly even if there is no bi directional connection.

[@SQLBI]

The visuals create a query that shows only combinations with a non-blank measures, the filter propagation is related to the effects on measures, mainly.