Tune your PowerPivot DAX query, don’t use the entire table in a FILTER and replace SUMX if possible
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