Visual calculations can either improve or degrade the performance of a report. In this article, we outline how we ensure visual calculations have a positive impact on performance. Read more
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