Forum Discussion
Optimize DAX query
Hi Vinnie,
Have many records did this query process? Did these content assigned in the premium capacity? If that's the case, you can try to increase the limit about query memory if it helps for your situation:
How to configure workloads in Power BI Premium - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi Anonymous , thanks again for your reply. This query processes about 6 million rows. I actually fixed the error I was getting on the visual.
The visual holds two measures (one for the amount (euro) of the outstanding amount and one for the amount of loans that have this outstanding amount). Both were calculated in the same way (so a group by loan number, and then sumx or countx).
I simplified the count by doing a distinctcount() instead of a group by (summarize()) and then countx().
It works for now but I am still wondering how I am able to measure the amount of MB a query is using. Is that possible?
The content is not assinged in a premium capacity.