BI Concepts BI Languages BI Tools Business Intelligence DAX Power BI Uncategorized

Handling Invalid Relationships in Power BI

Handling Invalid Relationships in Power BI

Hi All,

In this video, we will learn how to handle invalid relationships (blank rows) in Power BI using DAX.

The topics covered in this video are:

  • Overview
  • Case 1: Ideal case – only valid relationships
  • Case 2: Invalid relationships (blank rows)
  • Case 3: Demo – DAX measures and Power Query

Formulae for DAX measures:

  • Sales Amount = SUMX(FactSales, FactSales[SalesAmount])
  • Avg Sales Amount = AVERAGEX(DimProduct, [Sales Amount])
  • Avg Sales Amount Values = AVERAGEX(VALUES(DimProduct), [Sales Amount])
  • Avg Sales Amount Divide = DIVIDE([Sales Amount], DISTINCTCOUNT(FactSales[ProductKey]))
  • All Colors = COUNTROWS(ALL(DimProduct[ColorName]))

Find our YouTube channel at ML For Analytics. 

Follow us on Facebook at

Follow me on twitter at

If you like our videos, please hit the like button, add a comment, share our videos and subscribe to our channel. Stay tuned!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top
%d bloggers like this: