Blank row and limited relationships

DAX creates a blank row to guarantee that results are accurate even if a regular relationship is invalid. The blank row is not created for limited relationships. This video shows the effect of not having a blank row in your tables.
Article and download: sql.bi/785676?aff=yt
How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
The definitive guide to DAX: www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt

[@PowerBIHelpline]

Great as always 🙏 Thank you so much

[@matthewdufty606]

I quite like the blank row 💫 Great Video

[@rahul7rock]

Thank you for the wonderful explanation 🙂

[@saldevere9066]

I appreciate the blank row, and I know why I have the blank row in my data. I just wish there was an easy way to collapse it into another category on my dimension table when I choose. Otherwise my connection to the data source for the dimension will also have to have to append an anti-join to the fact table to add the missing rows to the dimension table source. Easy enough with SQL, but in the real world data isn't perfect, and executives with room temp IQs don't understand "blank".

[@davidfeliciofr]

Preat good! Thank you so much for you suport.

[@matsrosenqvist]

Thanks! 🙏

[@Amitkumar-nn5ds]

thanks

[@sbn4862]

Great video from great Man

[@KefasoNaib]

This is great! To be honest never paid any attention to the "broken lines". Just avoided many-many relationships and never worked with composite models that much :). I guess the smart use of "Dual Mode" for the objects on the link between the continents is the way to go in this kind of models to be sure the blank rows shows when it needs to?

[@mariuszkrzemien6576]

Hello, Is it possible to put measures in rows of matrix but in row will be also other variable and measures will be above this variable? Thanks in advance

[@SQLBI]

You can do that in Excel but not in Power BI - a possible workaround is moving measures to a calculation group or create a measure that chooses the actual calculation based on a slicer selection.

[@mariuszkrzemien6576]

@@SQLBI Thank you for your answer ;)

[@KefasoNaib]

@@mariuszkrzemien6576 Well, for Matrix Visual there is a switch in "Values/Options" Section of properties. Where you can turn on "Switch values to rows". Should do the trick.

[@AHMEDALDAFAAE1]

@@KefasoNaib Yes, it does. I am wondering how comes SQLBI missed that unless we are wrong