Forum Discussion
DirectQuery - COUNTX very slow
Hi expert, I use function COUNTX in formula : Number reference with a gap = COUNTX(FILTER(TABLE,[MEASURE]<>0),[REFERENCE]) This formula is then used in a chart. However, the graph takes a ...
Hi Juju123
It depends !
How big is your model?
What is the [Measure] expression?
Can you share a sample of your data table (few rows and all columns) if that does not have any sensetive data?
If your table is big, why not to only keep [REFERENCE] with Values using the same filter?
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!