This article describes how to apply different formatting rules at each level of a hierarchy (one rule at the year level, another at the quarter level, another at the month level) using ISINSCOPE in a measure or ISATLEVEL in a… Read more
In this article, we implement a function that removes filter-keep column filters from a calendar, using REMOVEFILTERS as the return value of the function. REMOVEFILTERS CALCULATE modifier Clear filters from the specified tables or columns. REMOVEFILTERS ( [<TableNameOrColumnName>] [, <ColumnName>… Read more
This article describes how to define optional parameters in DAX user-defined functions and set default values for parameters not specified by the caller. Read more
DAX offers many functions to remove filters from the filter context. In this article, we analyze the differences among the most commonly-used functions. Read more