Why and when you should use VALUES while iterating a table reference in DAX. VALUES When a column name is given, returns a single-column table of unique values. When a table name is given, returns a table with the same… Read more
SUMMARIZECOLUMNS is a powerful and complex function in DAX that in 2025 can be used in measures. This article outlines the best practices when using this function to avoid incorrect results. SUMMARIZECOLUMNS Create a summary table for the requested totals… Read more
This article describes the sideways recursion triggered by invoking a calculation item from another calculation item, explaining why it should be avoided to steer clear of unexpected results. Read more
For many years, SUMMARIZECOLUMNS has been a function dedicated to DAX queries and calculated tables, but it was not supported in DAX measures. Over time, Microsoft lifted the limitations, and in June 2024, the function was declared as fully supported… Read more