Forum Discussion
Helper IICorrect Totals for Measure
Hi Euro0681 ,
According to the error message, it seems that the visual request to query too much data and has exceeded the available resources. Please refer the following blog to solve your problem.
The “Visual Has Exceeded The Available Resources” Error In Power BI
And please try to update the formula of measure [FixAmount] as below and check if you can get the visual working...
FixAmount = SUMX ( VALUES ( 'TABLE'[category field] ), [AMOUNT] )In addition, you can refer the following links to fix the incorrect total values issue...
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Dax for Power BI: Fixing Incorrect Measure Totals
Best Regards
Hi Euro0681 ,
According to the error message, it seems that the visual request to query too much data and has exceeded the available resources. Please refer the following blog to solve your problem.
The “Visual Has Exceeded The Available Resources” Error In Power BI
And please try to update the formula of measure [FixAmount] as below and check if you can get the visual working...
FixAmount = SUMX ( VALUES ( 'TABLE'[category field] ), [AMOUNT] )
In addition, you can refer the following links to fix the incorrect total values issue...
Why Your Total Is Incorrect In Power BI - The Key DAX Concept To Understand
Dax for Power BI: Fixing Incorrect Measure Totals
Best Regards