Forum Discussion
Distinct count VS Countrows(values(....))
Hi guys, Can we replace DistinctCount() to CountRows(Values(..)) ? Which one is quicker ? I have a measure like this : OrderCount = CALCULATE(DISTINCTCOUNT('Order analysis'[order Id]), FILTER(...
Hi admin_xlsior ,
Many factors may affect the performance of power Bi, such as large data volume, data model and complex DAX expression.
You can refer to the following article to optimize the performance of power bi.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.