Forum Discussion
ncbshiva
Advocate V
Advocate VThe ALL DAX function is very slow.
Hi Team, I want to calculate some Average Price based on some logic and below is the DAX expression for that. Average Price = CALCULATE(DIVIDE([Dynamic Compare To];[FP&L Volume CompareTo];0);...
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi ncbshiva
It seems you may try to use ALLEXCEPT function.
https://www.sqlbi.com/articles/using-allexcept-versus-all-and-values/
Regards,
ncbshivaAdvocate V
Advocate VHi v-cherch-msft ,
Thanks for the reply , the problem with ALLEXCEPT is i cannot use more than 2 tables.
As you can see in my DAX formula , i have included around 7 tables.
Please let me know how can i improve the speed for this DAX formula.
Regards
SHIVA