Using variables to split up your calculations
Got a DAX question recently that I solved using variables. When I walked them through the solution someone exclaimed “I didn’t know you can do... Read more
Category: DAX
Dynamic relationships based on the selection
Got an interesting question recently where someone wanted to be able to switch the relationships automatically based on which slicer was selected. Take the following... Read more
Dynamically switching axis on visuals with Power BI
An interesting visualization pattern I have seen is that some customers want to be able to switch the axis on the chart dynamically using a... Read more
How to turn on SSAS profiler traces in Power BI desktop
Just a quick post today. Power BI desktop has a feature to turn on the SSAS profile traces that allows you to see all the... Read more
Currency conversion in DAX for Power BI and SSAS
Another interesting question that came up recently is how to do currency conversion in Power BI. My colleague Jeffrey Wang had a very neat solution... Read more
Filter data based on a comma separated list using CALCULATE and PATHCONTAINS, even with external models!
Another interesting question I got this week kind of extends on the previous blog posts where I used disconnected slicers to filter data but this... Read more
Use calculated tables to show only used rows in dimensions
I got an interesting request this week, to improve the usability of the tabular model they wanted to filter the dimension table to only contain... Read more
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