Report Portal

Optimizing mutually exclusive calculations

This article describes how to optimize DAX expressions with mutually exclusive calculations that might cause slow query performance.

In previous articles, we discussed the importance of variables and how to optimize IF functions to reduce multiple evaluations of the same expression or measure. However, there are scenarios where the calculations executed in different branches of the same expression seem impossible to optimize. For example, consider the following pattern:

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.