cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## The visual is exceeding available resources

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?

1 ACCEPTED SOLUTION
Super User

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?

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Super User

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?

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português