sum function exceeded the available resources

Question

Greeting members ,&nbsp;I have a table that contain details about the badging of employees (my table contains&nbsp; 9 millions rows )I created 5 measures that show how many a employees have badged (it's more like a flag)&nbsp; ex&nbsp; :&nbsp;&nbsp;* &gt;30 times = if(SUM(Badgeage[Pointage Vide]) &gt; 30 ,1,0)* 20-30 times = IF(and(sum(Badgeage[Pointage Vide])&gt;20,sum(Badgeage[Pointage Vide])&lt;=30),1,0)&nbsp;The problem members when i try to add these measures into a matrix that contain the name of the employees and their ID's etc ... i exceed the available resource .i tried to publish this into my premium capacity workspace (P1) that have 6Go memory and had the same issue .&nbsp;btw i checked the performance analyzer on power BI desktop and i notice the DAX are using too much memory&nbsp;is there a way i can optimize my queries please ?&nbsp;&nbsp;Thanks all in advance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

pratyashasamal · Accepted Answer

Hi&nbsp;Rayzo92&nbsp;,You can use Variable to optimize if Dax functions . Please check out this link :https://www.sqlbi.com/articles/optimizing-if-and-switch-expressions-using-variables/Thanks,PratyashaHas this post solved your problem? Please&nbsp;Accept as Solution&nbsp;so that others can find it quickly and to let the community know your problem has been solved.If you found this post helpful, please give&nbsp;Kudos&nbsp;C

Forum Discussion

sum function exceeded the available resources

1 Reply

Related content

Query Exceeded Available Resource

visual has exceeded available resources

Query has exceeded available resources

query has exceeded to available resources

Visual has exceeded available resources