Skip to main content
cancel
Showing results for 
Search instead 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

Reply
kzielinska
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
MFelix
Super User
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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

1 REPLY 1
MFelix
Super User
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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors