Correct Totals for Measure

[Euro0681]

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)

[v-yiruan-msft · Accepted solution]

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