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