Forum Discussion
Helper IICorrect Totals for Measure
I have created a measure that contains an "IF" Condition....
Amount = IF( [Quantity] <= 0 || [Price] <= 0 || [Fixed Price] = 0 , 0 , [Price] - [Fixed Price] )
row by row the number are correct, the issue is my total is incorrect.
I've tried using "SumX" to fix the total but i get the error "The Visual Has Exceeded Available Resources"
Is there any work arounds here or any other suggestions.
FixAmount = SUMX('TABLE',[AMOUNT])
(Second Measure for Reference)
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
1 Reply
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