Forum Discussion
Solved
DAX Crossjoin v Summarize
If I'm createing a virtual table for filtering, is there anything to choose between crossjoin and summarzie ? example ; table 3 = fact table ; EVALUATE CROSSJOIN( ALL( Table4[Name]) , ALL(...
Hello Dicken ,
SUMMARIZE is smaller, more efficient, especially if many combinations are not present in the data.
Respects relationships.
CROSSJOIN produces all combinations of Name × Items, regardless of whether they exist in the fact table.
Ignores relationships.So CROSSJOIN can be slower for large dimensions and SUMMARIZE is more efficient in filtered scenarios.
If you want every possible Name × Item combo you can use CROSSJOIN, if ou want only combinations that actually exist in the fact table you can use SUMMARIZE.
If this solved your issue, please mark it as the accepted solution. ✅
Thanks, that's pretty much what I thought, it's just sometimes difficult to visualise summariize.