Forum Discussion
Solved
Optimizing DAX measures to avoid "Exceeded available Resources" error in Power BI Services
Hi All, I am new to Power BI. For one of my visuals, In Power BI desktop, I am getting an error as “There's Not Enough Memory To Complete This Operation” and In Power BI Services, I am getting ...
- Hi there
One thing you could do to get an average is take the SUM and DIVIDE it by the Count
My Average = DIVIDE(SUM('Table'[fValues]),COUNTROWS('Table'))
And then use that as a basis for your other calculations.
Hi S_JO21rnr,
Here are some links about performance Optimization and tips about reducing file size for your reference:
Possible SWITCH Optimization in DAX
power bi performance tips and techniques
Best regards,
Yuliana Gu
Hi there
One thing you could do to get an average is take the SUM and DIVIDE it by the Count
My Average = DIVIDE(SUM('Table'[fValues]),COUNTROWS('Table'))
And then use that as a basis for your other calculations.
One thing you could do to get an average is take the SUM and DIVIDE it by the Count
My Average = DIVIDE(SUM('Table'[fValues]),COUNTROWS('Table'))
And then use that as a basis for your other calculations.