Receive updates from SQLBI for free, starting right now.
We can deliver them by email, via your phone or you can read them from a personalised news page on follow.it.
This way you won't miss any new article from SQLBI. Unsubscribe at any time.
Site title: Error 404 (Not Found)!!1
Is this your feed? Claim it!
Learn the differences between similar but different DAX functions that remove filters from the filter context.
DAX offers many functions to remove filters from the filter context. In this article, we analyze the differences among the most commonly-used functions.
Computing values in DAX is all about understanding how to manipulate the filter context to obtain the desired output. DAX offers a wide variety of functions to manipulate the filter context, including a rich set d...
User-aware calculated columns are not materialized: we can use them as virtual calculated columns for localization and for custom security scenarios. This feature is available through the new Expression Context property of calculated columns in Power BI.
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.
A calculated column is computed when the table is refreshed and stored in the model (in Impo...