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
This article describes the new Expression Context property of calculated columns in Power BI, explaining how user-aware calculated columns work, why they are not materialized, and how to use them as virtual calculated columns for localization and custom security scenarios. Read more
A slicer cannot filter a measure. In this article, we analyze this common request by explaining how to use a slicer to filter a measure, after discussing the real meaning of using a measure with a slicer. Read more