Tune your PowerPivot DAX query, don’t use the entire table in a FILTER and replace SUMX if possible

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

I was working on a PoC that needed a measure where I had to use some more advanced DAX functions. In this case I had two fact tables and the customer wanted to have the sales of a specific store, but only if they had a booking in the same period.

To cut straight to the DAX, this formula does the trick:



Tags: performance, dax, excel


2007-2015 VidasSoft Systems Inc.