Transform a heavy calculated measure accumulated into a column in Power BI

0 votes

Hello guys

So I've a table with more then 20.000 values and I need to do the accumulated sum of all of them...

I used this measure to do the calculation:

CALCULATE(

    SUM('Medições'[Vazão]),

    FILTER(

        ALLSELECTED('Medições'[Data Hora Medição]),

        ISONORAFTER('Medições'[Data Hora Medição], MAX('Medições'[Data Hora Medição]), DESC)

    )

)


It worked fine.. but whenever I upload my Power BI to the online platform, they show the error "power bi the visual has exceeded the available resources"

I tried to create a column using this measure, in a sense that it would be more like a static column... but it also didn't work

Any ideas???

Oct 23, 2020 in Power BI by marinafr
• 120 points

edited Oct 23, 2020 by Gitika 1,385 views

2 answers to this question.

0 votes

Hi, @Marinafr,

Yes, the issue occurs when a visual has attempted to query too much data for the server to complete the result with the available resources.

As suggested in the error, you may need to try filtering the visual to reduce the amount of data in the result currently.

answered Oct 23, 2020 by Gitika
• 65,770 points
0 votes
Hello, @Marinafr,

If you are using Pro License then the File size should not cross 1 GB and the total Workspaces size should not cross 10GB. Please check on that!

Try to remove unnecessary columns in the data so that you can save space.
answered Oct 23, 2020 by Rajiv
• 8,870 points

Related Questions In Power BI

+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,520 points
7,491 views
0 votes
1 answer

Difference between measure and calculate column in power BI

Hi Rahul,  With calculated columns, you can add new ...READ MORE

answered May 17, 2019 in Power BI by Cherukuri
• 33,030 points
10,712 views
+1 vote
1 answer

Stacked and a independent column chart in power BI

Hi Rahul, Follow the below steps: 1. Create a ...READ MORE

answered Jun 12, 2019 in Power BI by anonymous
• 33,030 points
10,336 views
0 votes
1 answer

How to rename a column using DAX in Power BI?

Hi Ramya, I found these two function that ...READ MORE

answered Aug 22, 2019 in Power BI by anonymous
• 33,030 points

edited Dec 31, 2021 by Soumya 37,221 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,130 points
1,350 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 22, 2018 in Power BI by nirvana
• 3,130 points
2,748 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,520 points
1,519 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,350 points
1,667 views
0 votes
1 answer

How to parse a .json column in Power BI?

Use Json.Document function like this let ...READ MORE

answered Dec 21, 2020 in Power BI by Gitika
• 65,770 points
2,948 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,480 points
79,081 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP