Should you use RANK or stick with RANKX? In which scenarios is one better than the other? This article provides an in-depth analysis to help readers make informed choices. RANK Returns the rank for the current context within the specified… Read more
This article explains the distinction between model-dependent and model-independent DAX user-defined functions, highlighting how dependencies impact portability and maintenance, and provides guidance on avoiding hidden dependencies and adopting proper naming conventions. Read more
This article outlines the process of creating a measure to identify the top 10 products by sales each year. Read more
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. VALUES When a column name is given, returns a single-column table of unique values.… Read more