Forum Discussion
Help w/Tricky Issue: Disconnected Table DAX Bucketing
Hi there, I've tried everything, & I'm at the end of my wits with this SSAS Tabular Model project. I think I'm getting accurate results now, but it's extremely slow and I can't pin down why. Any ...
So I might have made some progress. It appears changing Entity[Entity Key] here to use the SUMMARIZE instead makes most calculations go faster.
Does anyone know how to explain why?
I'm still a bit murky on expanded tables and data lineage. My best guess is that the Entity table can't access Customer, Document, or other dimensions, which caused cross joins or some other inefficiency.
I also updated the .pbix file: drive.google.com/file/d/128rvGqMmCFjvAUBMmr9x06Z1fjStihJW/view?usp=sharing