sum function exceeded the available resources

[Rayzo92]

Greeting members ,

I have a table that contain details about the badging of employees (my table contains  9 millions rows )

I created 5 measures that show how many a employees have badged (it's more like a flag)  ex  : 

* >30 times = if(SUM(Badgeage[Pointage Vide]) > 30 ,1,0)

* 20-30 times = IF(and(sum(Badgeage[Pointage Vide])>20,sum(Badgeage[Pointage Vide])<=30),1,0)

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 .

btw i checked the performance analyzer on power BI desktop and i notice the DAX are using too much memory 

is there a way i can optimize my queries please ? 

Thanks all in advance 

[pratyashasamal · Accepted solution]

Hi @Rayzo92 ,
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,
Pratyasha
Has this post solved your problem? Please Accept as Solution 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 Kudos C