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 in Power BI by marinafr
• 120 points

edited Oct 23 by Gitika 87 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 by Gitika
• 48,440 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 by Rajiv
• 4,560 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,410 points
4,372 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 16, 2019 in Power BI by Cherukuri
• 32,490 points
5,184 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
• 32,490 points
4,582 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 21, 2019 in Power BI by anonymous
• 32,490 points
6,216 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,120 points
262 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 21, 2018 in Power BI by nirvana
• 3,120 points
1,302 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,410 points
351 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
• 51,970 points
364 views
0 votes
1 answer
0 votes
1 answer

How to troubleshoot a refresh on data set in power bi service

Hello, @vnk, You may see an error when ...READ MORE

answered Sep 14 in Power BI by Gitika
• 48,440 points
52 views