This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services. Read more
The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. SWITCH Returns different results depending on the value of an expression. SWITCH ( <Expression>, <Value>, <Result> [,… Read more
If you try to use SELECTEDVALUE on the visible column of the table generated by the Fields Parameters feature in Power BI, you get the following error: Calculation error in measure ‘Sales'[Selection]: Column [Parameter] is part of composite key, but… Read more
This article explains how to use KEEPFILTERS to intersect instead of override an existing filter context in DAX. Using KEEPFILTERS simplifies the code and improves performance. KEEPFILTERS CALCULATE modifier Changes the CALCULATE and CALCULATETABLE function filtering semantics. KEEPFILTERS ( <Expression>… Read more