COUNTX or COUNTROWS to count rows of a filtered table?

[Dhania_BI]

Hello,

I was wondering which of the following measures is the best to count rows of a filtered table (and why) ? Is there actually a difference? The result in the same in my report.

Measure1 = COUNTX(FILTER(Table, Table[Unit price] >300), Table[Unit price])

Measure2 = COUNTROWS(FILTER(Table, Table[Unit price] > 300))

Thank you very much for your help.

[Anand24 · Accepted solution]

Hello @Dhania_BI ,

COUNTX will exclude white space and Boolean data, while COUNTROWS will also count them.

In addition, COUNTX is generally used for the appearance of measurements or numeric values.

You will get the same result in your case using both, as you are counting values from the filtered table.

Here's a video that could help you: https://www.youtube.com/watch?v=y2GPFFOW3fA

Give it a thumbs up if this post helped you in any way and mark this post as a solution if you solved your !!!

[Dhania_BI]

Thank you Anand, all clear!