Forum Discussion
Default item calculation groups
Hi all, I've created a calculation group for time intelligence calculation. Due to the setup of our tooling, I need DAX to default to a default item if you don't select anything. Let's say I...
It depends, usually a project takes about 100-200k rows, but occasionally it also goes into the multiple millions of rows for the dataset.
Is there a known performance impact of using variables this way?
I did do a performance test of the old switch solution vs the new calculation group methodology with the variable, and it looks like the performance of refreshing reports is almost similar.
Hi bgc200 ,
I don't have experience with very large data sets. But when you use a variable, it will only evaluate the expression once and store the result in the corresponding variable. This is good for performance.
Best Regards,
Wenbin Zhou