Topic: Relationships
-
This article describes when to use VALUES in a table grouped by SUMMARIZE, then goes on to explain why you cannot however use VALUES with SUMMARIZECOLUMNS. Read more
-
Why and when you should use VALUES while iterating a table reference in DAX. Read more
-
When should you use DISTINCT over VALUES in DAX? Here is how to write resilient measures that survive bad data and model changes. Read more
-
This article explains why you might encounter a curious error when placing columns from unrelated tables in a Power BI matrix. Read more
-
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 article shows the effect of not having a blank row in your… Read more
-
Avoid circular dependencies when calculated columns or tables are involved in regular one-to-many relationships. Related articles: https://www.sqlbi.com/articles/blank-row-in-dax/ https://www.sqlbi.com/articles/expanded-tables-in-dax/ Watch now
-
This article describes the types of relationships available in Power BI and Analysis Services, clarifying the differences in cardinality and filter propagation of physical relationships. Read more
