Forum Discussion
Couldn't load the data for this visual - Sumx
Hello, I'm making a report with sales figures for different regions. At first, I created a measure for a month-to-date total. TOTALMTD(SUM('salestbl'[Value]), 'Date'[Date]) However, the totals...
Hi v-cherch-msft,
Below image shows the problem with the use of the first SUM formula:
As you can see, the total doesn't equal the sum of the subtotals (should be 76781) for BCX MTD.
So correcting this with the SUMX formula, resolves this problem, but leads to error 'Visual has exceeded the available resources' in the service for unfiltered data.
Regards,
Jonne
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous
You may try to use IF Function to change the total in your visual. Here are the references for you:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
If it is not your case, please share the data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here.
Regards,
Cherie