Forum Discussion
Performance issues with SUMX
Hi I have huge performance issues by implementing a scenario with this setup: - Fact table containing ~ 14 Mio. rows and 5 columns - Proper star scheme implemented - Import mode used - Filesi...
You are doing a SUMX without any filters. is that intentional?
Instead of VALUES try to use SUMARIZE or SUMMARIZECOLUMNS with ADDCOLUMNS.
Hi lbendlin
Thanks for your response.
It's basically intentional, because I need every single record to get the correct values for the total and I'm not aware of any possibility to summarize / group the data from a business point of view.
But I will definitely take a look a the suggested functions!
Best regards,
PBI-Enthusiast