Forum Discussion
COUNTROWS Function
Hello, please I cannot understand why the DAX query below give an empty result. In fact, the function inside the COUNTROWS works well and the result is a table. But the COUNTROWS doesn't work. Plea...
Sorry, I'd focussed on the SUMMARIZE and totally missed what the SELECTCOLUMNS was doing!
When you add the COUNTROWS in have you tried dropping the measure into a card on an empty page with no report filters set. Just wondering if something is already in the filter context.
Hello bcdobbs,
your are right. There was a filter context in my file. The query works well in an empty file.
Thanks once more.
Regards