Forum Discussion
Advocate IDAX Optimisation Cumulative DISTINCTCOUNT
Thanks for reaching out to us.
please refer to
(1) FILTER vs CALCULATETABLE: optimization using cardinality estimation - SQLBI
" It is correct to assume that separate filters are better, but if you have many filters and a distinct count calculation, you might try to consolidate filters in order to improve performance. I expect this behavior to be improved in future releases of Power Pivot and Analysis Services Tabular."
(2) Why my Power BI Matrix or Table Visual is SLOW - RADACAD
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Community SupportThanks for reaching out to us.
please refer to
(1) FILTER vs CALCULATETABLE: optimization using cardinality estimation - SQLBI
" It is correct to assume that separate filters are better, but if you have many filters and a distinct count calculation, you might try to consolidate filters in order to improve performance. I expect this behavior to be improved in future releases of Power Pivot and Analysis Services Tabular."
(2) Why my Power BI Matrix or Table Visual is SLOW - RADACAD
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.