Use calculated tables to show only used rows in dimensions
UPDATE: you can now use measures as filter of a slicer so this post is outdated, please read here for what the recommendation is today:... Read more
Category: DAX
Dynamic data comparisons using disconnected slicers, TreatAs and inactive relationships
Got a good question this week that had me scratching my head for a bit but then I remembered a new function that was added... Read more
Use the Power BI quick calcs with your own date table
Just a quick one today on how you can use the Power BI quick calcs with you own date table. I have a very simple... Read more
Automatically apply filters to your report per user
This was an interesting case I did a while ago where they wanted to have a report that automatically provided a set of filters to... Read more