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.
@SolutionsAbroad2 жыл бұрын
Glad it helped! Thanks for watching and the for the sub!
@jevieacop Жыл бұрын
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?
@Pasar24903 жыл бұрын
Great video! I have a question. Why if we want to count everything in the row except a specific value?
@SolutionsAbroad3 жыл бұрын
Hi Sara, if you want to count everything except a specific value, you'll need to use the CALCULATE function to apply a filter context to your count. From memory, I covered this in a previous video, check it out if you haven't yet kzbin.info/www/bejne/iaOWgJd7Ys-rlZo Hope it helps!
@openuni78092 жыл бұрын
also DITINCTCOUNTNOBLANK - To avoid the blank one (:
@DashMcunfast11 ай бұрын
How are you displaying the data table here? ... Are you just using the table visualisation?
@DiCh-jp8ms Жыл бұрын
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.
@ToniaLNewton Жыл бұрын
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.
@shikha_bebo293 жыл бұрын
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?
@SolutionsAbroad2 жыл бұрын
Hi Shikha, the count should work as long as the values are non blank
@MoonShine-bs6cl9 ай бұрын
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.
@SivaPonakala Жыл бұрын
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. ..
@aidakalantari6800Ай бұрын
Very clear explanation. Good job and thank you for sharing
@MS-xg4ep2 жыл бұрын
Somehow the COUNT also counts the ZEROs in a row? Why is that the case?
@saikumarp-s2t10 ай бұрын
Why can't we apply the distinct value count to the card visual when I create as measure
@zhengsiyuan56953 жыл бұрын
Great Video! I have a question. How do you put your raw data table here.
@SolutionsAbroad3 жыл бұрын
Hi Zheng, great question! You need to use the "Get Data" option in the ribbon to import your data into Power BI. Hope that helps!
@amirbitan3 жыл бұрын
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
@SolutionsAbroad3 жыл бұрын
Hi Amir, it sounds like you need to use the "Keep Duplicates" functionality in Power Query. Then from there you can either just do a count/countdistinct or do a "Remove Duplicates". Hope that helps!
@jackjohnshei83743 жыл бұрын
hi i am using distinct count in excel ,how to exclude blank cells from pivot table.because blank cells value here showing as 1.
@SolutionsAbroad2 жыл бұрын
Hi Shane, I gotta be honest I'm not too familiar with Power Pivot. Can you not add an implicit filter to exclude blanks or N/A?
@kayeiaramariedeocampo79803 жыл бұрын
Great Video! One question, what if I want to count the number of occurence of a specific Order ID?
@SolutionsAbroad3 жыл бұрын
Hi Kaye, great question! You might want to look at using "Group By" on your Order ID, this will give you a count of occurrences for each ID. Alternatively, you can also created a calculated column, maybe this will help: community.powerbi.com/t5/Developer/How-to-count-the-occurrences-of-each-value-in-a-column-including/td-p/151328
@kayeiaramariedeocampo79803 жыл бұрын
@@SolutionsAbroad Hi I tried but it keeps removing other columns. How can I retain the existing columns (that is part of the data set, but not a reference for the thing I'm counting) thereafter? For example, I tried creating a counter for a Record ID, after selecting the column, applying Group by, it does give me the column for counter, but deletes automatically the rest of my data set. Can't figure it out. huhu
@SolutionsAbroad3 жыл бұрын
@@kayeiaramariedeocampo7980 Hey Kaye, a quick, non-complicated solution is to just create a duplicate query of this one before the GROUP BY, then merge it back so you can get your other columns. The Group By has to exclude the other columns so it can be grouped by ID, hope it helps!
@kayeiaramariedeocampo79803 жыл бұрын
@@SolutionsAbroad Thanks!
@SolutionsAbroad3 жыл бұрын
@@kayeiaramariedeocampo7980 you're welcome, good luck!
@manuelboadi1343 Жыл бұрын
Please I want to write a measure that counts the most occurring number in a column
@vipulgoel41563 жыл бұрын
How to count the number of times a text value appears in a column?
@SolutionsAbroad3 жыл бұрын
You might need to do a countif alternative in DAX to do this: www.goodly.co.in/countif-power-bi-dax/
@nehatalwar75673 жыл бұрын
I am confused,I see count is taking blank value for me. Is that count takes blank value as well.
@SolutionsAbroad3 жыл бұрын
Hi great question! Blank values are skipped docs.microsoft.com/en-us/dax/count-function-dax
@faizanbhat2626 Жыл бұрын
count function calculates blank cells as well for me.
@sathyanague3329 Жыл бұрын
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?
@thermant84522 жыл бұрын
Good stuff! Thx!
@SolutionsAbroad2 жыл бұрын
Glad you liked it!
@EngineeredFoodies2 жыл бұрын
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.
@giridharnaidu36622 жыл бұрын
What are the most common DAX functions used in power bi in real time.. Can u cover a video in this specific topic..
@SolutionsAbroad2 жыл бұрын
Hey there, thanks for watching! I covered my top 5 DAX functions here: kzbin.info/www/bejne/p3ecln6ArbloeMk
@saikumarp-s2t10 ай бұрын
How to display the row count to each record
@arunkumarramachandran56472 жыл бұрын
The letters are not clear , pls zoom the formula bar .
@jermainecameron62093 жыл бұрын
How can we count distinct values with expression filters like you did with the countx
@SolutionsAbroad3 жыл бұрын
Hi Jermaine, for that you will have to use a combination of DISTINCT COUNT and FILTER, here's an article that covers that community.powerbi.com/t5/Desktop/Distinct-countx/td-p/154867
@jermainecameron62093 жыл бұрын
@@SolutionsAbroad thank you so much, it worked perfectly
@mivanows Жыл бұрын
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.
@PhillipLearnTeach3 жыл бұрын
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?
@SolutionsAbroad2 жыл бұрын
Hi Phillip, measures and calc columns are identical but not similar. Here's a video explaining how they're different: kzbin.info/www/bejne/pKSXh5Wmh7B0fNU Measures can reference columns or measures anywhere in the dataset Calculated columns is data within a table, if you want to reference columns from other tables, there has to be a relationship that connects those tables together, here's a video on relationships if it helps: kzbin.info/www/bejne/hYDWXomNm5dje5o
@anino68 Жыл бұрын
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.
@umagbaalex16242 жыл бұрын
Thanks, Fernan for your videos. Very helpful to me. How do I connect to you on Linkedln
@baastech78402 жыл бұрын
perfect man
@SolutionsAbroad2 жыл бұрын
Thanks!
@abdulqadeerkamangar62793 жыл бұрын
How can we select top 3 products or countries based on count (product and countries separate columns)?
@SolutionsAbroad3 жыл бұрын
Hey there, I covered that topic in this video: kzbin.info/www/bejne/rKGqcplsg9CnZ7M
@tllittle2 жыл бұрын
Nice 👍🏽, new subscriber
@danielosorio217 Жыл бұрын
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!
@SivaPonakala Жыл бұрын
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
@1985mercedesbenz5 ай бұрын
thank so much
@jlcanada6912 Жыл бұрын
Dude! Speak way too fast!
@cazvon43462 жыл бұрын
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.
@khalidmajeed2886 Жыл бұрын
why y cant make it in zoom it is tiny
@faizaa54767 ай бұрын
Such a good video, slowly starting to become a pro on power bi. THANK YOU SO MUCH!
@BSITVinluanEner Жыл бұрын
Thanks Broooo , loveit
@rajm53492 жыл бұрын
can u xplain any project
@MariaL-x7d Жыл бұрын
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.
@tuncohighway79222 жыл бұрын
Excelent video sr!
@yonwabangwenze22513 жыл бұрын
This is really helpful. Thanks
@SolutionsAbroad3 жыл бұрын
Great stuff, thanks for checking it out!
@gbolahanl42803 жыл бұрын
Thanks for the video. It is very helpful
@SolutionsAbroad3 жыл бұрын
You are welcome
@natynt227 Жыл бұрын
just perfect tks sir
@davidgitau88252 жыл бұрын
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,
@shyjumathew076 ай бұрын
Good one, thanks
@jaitiwari2412 жыл бұрын
Please share dataset
@jaybilakhia56953 жыл бұрын
Just saved me >1 Hour Thanks
@SolutionsAbroad2 жыл бұрын
You're very welcome!
@kennethstephani6923 жыл бұрын
Great video!
@SolutionsAbroad3 жыл бұрын
Thanks for watching!
@bouldy73 ай бұрын
Thank you for the Countx Filter measure! Hero
@leslieliew57122 жыл бұрын
I have 37 bathrooms…How can I calculate the percentage of bathrooms that are cleaned twice a day at each location?
@agapheputrasusilo7417 ай бұрын
THANKSSSSSS
@almyvblog79892 жыл бұрын
Please make a video connecting Power Bi to Mongodb
@alejandropatino9095 Жыл бұрын
Great!
@CCS-o2i7 ай бұрын
very clearly explained. Thank you!
@Phoenixspin3 жыл бұрын
I learned to count in kindergarten.
@ibrahimburhankonuk Жыл бұрын
Perfect explanation, worth to watch for every sec.
@chinmayjoshi977 Жыл бұрын
thanks for the video! super helpful
@VeganSmasher3 жыл бұрын
Fantastic video. Thank you!
@SolutionsAbroad3 жыл бұрын
Glad you liked it!
@matthewshotton86 Жыл бұрын
Amazingly explained for the refresher I needed, thanks for all the great content!
@great_filter2 жыл бұрын
Thank you very much
@SolutionsAbroad2 жыл бұрын
You're welcome!
@Devloper562 жыл бұрын
Perfect and practical explanation about the count function !!! Thank you brother
@wesleyharper3253 Жыл бұрын
Worked like a charm!
@SolutionsAbroad Жыл бұрын
Fantastic great to hear!
@aleksanderstrommer76773 жыл бұрын
Great example!
@SolutionsAbroad3 жыл бұрын
Thank you!
@letthemknowuncle5399 Жыл бұрын
Amazing explanation 😁
@jbmh9339 Жыл бұрын
This is awesome! Your videos helps me a lot!
@gintomino41362 жыл бұрын
so countx and countax are like calculate with count, interesting
@SolutionsAbroad2 жыл бұрын
Something like that, they are iterators and basically allows you to add extra filter context, similar to calculate!
@mayanknema3007 Жыл бұрын
Awesome explanation. You cant get better than this on this topic.
@philipwatuma71203 жыл бұрын
Very useful thanks
@SolutionsAbroad3 жыл бұрын
You're welcome, thanks for watching!
@divyaparekh67213 жыл бұрын
you explain really well
@SolutionsAbroad3 жыл бұрын
thanks for watching!
@gnavarrolema2 жыл бұрын
Great explanation...it is much clear to me how to use these functions. Thanks.
@SolutionsAbroad2 жыл бұрын
Glad it was helpful!
@allaboutfoodzbydebd86273 жыл бұрын
awesom
@SolutionsAbroad3 жыл бұрын
Thank you!
@EMKworks3 жыл бұрын
Excellent layered 10 minute video, being able to see the table and the counted numbers on the one page seriously good idea. Well done!