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 177 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,970 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,910 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,570 points
5,721 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,010 points
7,718 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,010 points
6,963 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,010 points
12,273 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,150 points
409 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,150 points
1,614 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,570 points
538 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,370 points
593 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,970 points
644 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
32,631 views