The visual is exceeding available resources

[kzielinska]

Hi! I have a measure:

Net Value= Sumx(summarize(table, table[document], table[net_value]), [net_value])

which for distict document takes its net_value and summarizes it with others. The problem is this table has 20 milion rows, and when I upload my power bi to the power bi workspace I can't see visuals which include this measure.

What can I do about that? 

[MFelix · Accepted solution]

Hi @kzielinska ,

Since you are doing a SUMX, this is getting  all the lines of the table and making a row by row calculation,

Why are you using a SUMX to make this interaction? Can't you use a simple sum?

The formula you are using is first group the documents, adding a line per each net value and then summing them up what happens in your calculation is the following;

Document	Net Value
A	10
A	10
A	20
B	15
TOTAL	55

SUMX is doing:

Document	Net Value
A	10
A	20
B	15
TOTAL	45

The final value you want is the 45?