A few months ago, I started a series of posts about “translating” Tableau functionality to Power BI functionality and terminology (FIXED LOD example). Continuing that series, one of the new features in Tableau 2018.3 is the concept of Set Actions, which allows users to build interactivity between sheets on a dashboard. Andy Cotgreave wrote a…
In Tableau, INCLUDE level of detail (LOD) expressions are used to obtain values for dimensions that are not directly used in a visualization. This final LOD post focuses on adapting Tableau INCLUDE LOD expressions to DAX in Power BI. See previous posts on FIXED and EXCLUDE as well. With FIXED, I used the counterpart ALLEXCEPT function…
In a recent post on Tableau level of detail (LOD) expressions, I explored a method to translate FIXED to DAX in Power BI. Continuing that theme, I’ll now attempt to show an equivalent for the EXCLUDE keyword. While EXCLUDE and INCLUDE are not as common as FIXED in my experience, I’ve started down the LOD…