Perfect explanation, just what I was looking for! I've watched many videos, but no one explains it the way you did. Thank you again! Subscribed.

Very clear explanation. Good job and thank you for sharing

Thank you for the Countx Filter measure! Hero

Such a good video, slowly starting to become a pro on power bi. THANK YOU SO MUCH!

Perfect explanation, worth to watch for every sec.

Amazingly explained for the refresher I needed, thanks for all the great content!

Excellent layered 10 minute video, being able to see the table and the counted numbers on the one page seriously good idea. Well done!

Hey Fernan! Thanks for your videos, I've been following you for quite a while now and it helps me a lot in my work related projects. Are you a Filipino?

Worked like a charm!

Perfect and practical explanation about the count function !!! Thank you brother

very clearly explained. Thank you!

Excellent explanations! I'd like to know how to use the functions, particularly using CountX and CountAX to count "text" values (non Boolean) rather than numerical. I have a table with vendors/suppliers that deliver different parts. Some of the vendors deliver some of the same parts, so two vendors may have the same Part No.. Parts per vendor are marked as delivered Early, On-time, and Late. I want to count each of these three delivery statuses per part and vendor to then calculate the percentage of each delivery status per vendor out of the Grand Total of all deliveries and the percentage based on each delivery type/status. For now, this is the formula I came up with to count early deliveries: _CountX = COUNTAX(FILTER(Delivery, Delivery[Delivery Type] = Early()), Delivery[Delivery Type]) Thanks for your help!

Good one, thanks

thank so much

Awesome explanation. You cant get better than this on this topic.

Great example!

you explain really well

This is really helpful. Thanks

Clearly explained supported by simple visuals - makes learning less complicated. One question, why would you not use the COUNTA and COUNTAX functions all the time as they can handle numeric, text and binary strings? Is it a refresh performance issue? Thank you.

Great explanation...it is much clear to me how to use these functions. Thanks.

Just saved me >1 Hour Thanks

just perfect tks sir

Good stuff! Thx!

count function calculates blank cells as well for me.

Excelent video sr!

This is awesome! Your videos helps me a lot!

Great video! I have a question. Why if we want to count everything in the row except a specific value?

perfect man

Thank you very much

Thanks for the video. It is very helpful

Great video!

Amazing explanation 😁

What are the most common DAX functions used in power bi in real time.. Can u cover a video in this specific topic..

thanks for the video! super helpful

Fantastic video. Thank you!

Great Video! One question, what if I want to count the number of occurence of a specific Order ID?

Great explanation.... Maybe you can help me with a matter, I need to count the codes of the clients that are repeated during different years. For example, customer 373 checked in 2020, 2021, 2022 = 3 unique times. Thanks for your help.

Hi your teaching is great but how can i avail the pbix demo files which u have used in the videos for practice, please help.

Very useful thanks

Nice 👍🏽, new subscriber

MeasureName=CountRows(CalculateTable(Table, Filter1,filter2))--CalculateTable gives you an opportunity return a subset of the table, with rows that meets criteria specified in the filters. Then use countrows to get subset count,

THANKSSSSSS

Great!

Great Video! I have a question. How do you put your raw data table here.

Would you know how to count # of rows based on conditions on calculated measures? Measures are based on 2 different tables with one related column.

How are you displaying the data table here? ... Are you just using the table visualisation?

Why can't we apply the distinct value count to the card visual when I create as measure

Great video! What if both the columns I am evaluating in the expression “COUNTAX(FILTER(People, People[business_unit] > 1),People[IsManager])” are of text data types?

How do you make a measure or a calculated column that consist of a measure and certain values from a columns from either same table of separate table?

Can we show count of null values against each column from a table in a single visualization .. I do not want to use countblank for each column individually.. please suggest

Thanks Broooo , loveit

how can I show number of null values in each column from a table at a time in a table or matrix visual ? is there a way, Please suggest. ..

How can we count distinct values with expression filters like you did with the countx

Hi i can`t fiure out a problem with counting. I have a table with 5 names of people that are repeated multiple times in the table and next to this column i have another one with a status "Yes" or a blank cell. I want to count only the times that a name apears with a status yes. For example i have John repeated 5 times, 3 of which are with status yes and David repeated 3 times and 2 times are with statu yes. I want to make a table in which to show the names and how many times they have status Yes.

How does one count how many time a certain value is in that column. As in how many times 10 is listed. I can't get it to work for NPS.

Great video. I have this problem: how to create a measure that counts how many specific values appear in one column when the values in another column is not unique column 1 column 2 a 1 b 2 a 3 a 1 b 4 a 5 b 6 the answer I expect to get is 3 not 4 Thanks

How to count the number of times a text value appears in a column?

Hi I am facing issues in the distinct count. When i use column distribution in power bi query editor the value of distinct count is right. But when I tried to calculate the same value for the same column in power bi desktop the value was different. Need your support.

I am confused,I see count is taking blank value for me. Is that count takes blank value as well.

hi i am using distinct count in excel ,how to exclude blank cells from pivot table.because blank cells value here showing as 1.

How to display the row count to each record

How can we select top 3 products or countries based on count (product and countries separate columns)?

Please I want to write a measure that counts the most occurring number in a column

Hi, I had one doubt in Power BI. I have made one measure (consider Measure 1) on distinct count for respective column which is fine. Similarly I need to pick another column based on this measure 1 which has both values and numerics. How could be done, Sir. UNIQ ID RANGES 077GGG 1 077GGG 1 077GGG 1 078GGG null 078GGG null 079GGG 5 079GGG 5 079GGG 5 079GGG 5 079GGG 5 080GGG 1 080GGG 1 081GGG null 081GGG null 081GGG null In UNIQ ID column. I have used measure as distinct count and in card i will be getting 5 count On the RANGES column, when I use card, I need to get 3 count -----> stating like avoiding the nulls and getting 1 for 077GGG 5 for 079GGG 1 for 080GGG Could u pls help on this, Sir?

also DITINCTCOUNTNOBLANK - To avoid the blank one (:

I have 37 bathrooms…How can I calculate the percentage of bathrooms that are cleaned twice a day at each location?

can u xplain any project

awesom

Please make a video connecting Power Bi to Mongodb

Please share dataset

The letters are not clear , pls zoom the formula bar .

Somehow the COUNT also counts the ZEROs in a row? Why is that the case?

Please help! I want to replicate the same result in Powerquery. Here is the example in Excel: 56 77 46 3 ->formula =COUNT(A1:C1) 33 54 2 ->formula =COUNT(A2:C2) Note that the A2 is [empty] - the count result is as expected (=2) I can't find a way to replicate it in Powerquery. Powerquery returns 3 - it is considering the empty as [NULL] and counting - the result is =3, but it should be =2.

why y cant make it in zoom it is tiny

so countx and countax are like calculate with count, interesting

I learned to count in kindergarten.

Dude! Speak way too fast!

Thanks, Fernan for your videos. Very helpful to me. How do I connect to you on Linkedln