Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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])
Solved! Go to 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 !!!
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 !!!
Thank you Anand, all clear!
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |