Unfortunately, when I try to make a table with combined sales for all regions (full country), I get the error 'Couldn't load the data for this visual'. On a filtered dataset however, it works fine. I've read that this may be due to the SUMX part, as it evaluates every single row.
Is there a way to optimise this measure so it won't take so much memory so I can report on the full dataset giving the possibility to see the country total next to the region total (in another table)?
You may try to check which dimension should be used in the table. And the relationships between your tables.If it is not your case, please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here.
Community Support Team _ Cherie Chen If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.