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 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.
