Totals Not Coming Correct Virtual Table

@AntrikshSharma,
Always good to see how others come up with solutions. I took a look at yours and have a few notes (if you dont mind :slight_smile: )

When you FILTER over a SUMMARIZE table it results in the Storage Engine (i.e. the fast one) not being able to complete that task and has to get some help from the Formula Engine, resulting in CallbackID, which degrades performance. When we run in Dax Studio, we can see that happening.

Crossjoin doesnt suffer from that issue, but doing a cross join will bring in more data that it is needed since crossjoin produces all the possible combinations, which can bring in more data that is necessary.

Not a huge deal in a small model like this. Just wanted to share my thoughts since I’ve been really getting into performance tuning lately.

-Nick

4 Likes