Calculation And Filtering With DAX

Kevin Feasel



Koen Verbeeck is looking to optimize code which uses CALCULATE and FILTER together:

There have already been many posts/articles/books written about the subject of how CALCULATE and FILTER works, so I’m not going to repeat all that information here. Noteworthy resources (by “the Italians” of course):

In this blog post I’d rather discuss a performance issue I had to tackle at a client. There were quite a lot of measures of the following format:

Click through for a couple iterations of this.

Related Posts

Replacing DAX PathContains With OR

Chris Koester shows the performance benefits of replacing the PathContains function in DAX with a simple OR operator: This post shows how you can generate optimized multi-value DAX parameters in SSRS and achieve greater performance compared to the DAX PathContains function. This will be a short post that provides the SSRS expression to convert multiple SSRS parameters […]

Read More

Variables In DAX

Matt Allington shows us how to use variables in DAX: Variables in DAX is a relatively new feature and is available in Power BI Desktop Excel 2016 SSAS Tabular 2016 Variables are not available in Excel 2013 or Excel 2010. Click through to see how to assign and use variables.  It’s interesting to see how […]

Read More


September 2017
« Aug Oct »