How to COUNT in Power BI | COUNT, COUNTA, DISTINCTCOUNT, COUNTBLANK,COUNTROWS , DISTINCTCOUNTNOBLANK

In this video I go through the SIX different ways you can count using DAX in Power BI.
Counting is probably one of the most common functions you would've been using if you work a lot of with data. Did you know that you can do more with your COUNTS in Power BI?
Here's a TLDR version of the video if you don't want to watch the whole thing:
- COUNT - Count Non-Blank Values
- COUNTA - Count Non-Blank Values, accepts TRUE/FALSE types
- DISTINCTCOUNT - Count unique values
- COUNTBLANK - Counts blank rows
- COUNTROWS - Counts rows in table
-DISTINCTCOUNTNOBLANK - Count distinct rows ignoring blanks
#PowerBI​ #DataAnalytics​ #BusinessIntelligence #dax #bitips #bi #powerbidax

[@olxolx203]

w888888ing 4 nxt video on count x dis video cool THE bindu = super cool power bi instructor the flow of xplantin amazing = simple and best; to d point do 5 videos/day plzz......i JUST need it

[@mansijswarnkar4389]

Hi Bindu, thanks for this nice video. I was wondering how one could Percentage formula as per group in a special scenario when the column is of String values. Example % of Name/Surname/Ticket No etc display as a M/M, W/w trend? Any idea/suggestion would be a great help. Thanks

[@anilkumarjilloju3147]

Hi Hello Mam Good Morning plz send me Count Functions Excel Sample Data

[@TheHimaBindu]

Hi . Not sure if I saved it. I will post it here if I saved. Will make sure to add the files in the future videos

[@rachitsharan9511]

Hi All, if anybody could help me out, I have a table which has around 1000 rows of data which also includes IDs, I wanted to creat a column in Power BI which shows the count for how many time the ID is repeated throughout the Column, can someone help me out?

[@makalontsasa4106]

How do I calculate the percentage of females in a gender column with males and females?

[@olxolx203]

u earned a new subscriber power bi best = THE BINDU = directly on target d EXACT xplantion of functions in SIMPLE form the bindu; the bindu ; the bindu !!!!

[@TheHimaBindu]

Thank you for the complement 🙂

[@ajeyarjun8718]

Hi @Bindu, simple explanation and very understandable

[@shanepatel8076]

Hi How to create measure using multiple filter from same column. Thanks

[@Elite_leads]

hello Hima, i would like to ask, how can I count the only male in a column that contains Male and Female

[@kraghava3584]

Good info... Nd clarification and no where I found in Countx

[@EVSprakash]

next vidieo can u share and data set also can u share the link mam

[@jaipal007]

Explained nicely.. Description content is good for easily understanding..Meru easy ga ardhamaiyyetatlu examples to chebutunnaaru andi...Thanks.

[@TheHimaBindu]

Thank you 🙏

[@thotasuresh3928]

What is cumulative sales in power bi

[@pranitachavan6936]

Hello mam , your video is very usedful in real work can you post COUNTX and COUNTAX video

[@TheHimaBindu]

Sure . Will do

[@vijaykotapati8042]

Tnq madam meeru chesina videos valana I get a 80% knowledge on Bi tnq madam meeru dax midha inka konni videos cheyali ani korukuntuna

[@TheHimaBindu]

Thank you Vijay. Will definetely do more videos on Dax

[@pasularamakrishna882]

plz provide pbix file for practice

[@naveenboniga7859]

First opal thanks for giving this valuable knowledge. could u please tell about row level security and some daily used DAX functions for business need. Thanks.

[@TheHimaBindu]

Will do. Thanks !

[@sivajiganga863]

How to count only True or False

[@mzcpmzcp461]

can i send some files

[@AmolPuranik-bm8nu]

could you explain? how do you calculate the 'has_driven_Licence' column?

[@johnsonrajan6733]

Thanks Bindu for your wonderful simple explanation...

[@binginaresh141]

How can we take running count of specific column (As COGNOS running count)

[@subbunaidu301]

For example in column, find out the how many 10's are their in column or how many 8's are their

[@banashreechatterjee7387]

Hello Bindu, how can I use count function to count the number of rows with negative numbers. I'm unable to use countif function.

[@nazmulhaque3894]

Nice to learn

[@dheerajreddy3559]

Thanks for the video. How can I count only true or only false ??

[@sirfan9281]

Good video

[@vrajjindal38]

Nice video... Can you suggest how to count agentwise number of places visited in less than 10 minutes gap through excel power query or DAX. In the table, first column contains agent name and second column contains time of visit.

[@narayanjena4259]

Wow You clear all these concept very clearly and easily. Thnak you.

[@ravisunkara6664]

Good explanations on count dax. Thank you Madam?

[@chandubathala]

Please provide dataset(table) links for all videos

[@TheHimaBindu]

Will add it

[@sudhirrao3683]

Good Presentation . Explained clearly

[@sureshbabumarri]

Good information about how to count in Power BI

[@Nrsouth12]

Hi how can I use the count function to count the wait time above 5 minutes?

[@rajurao7637]

Thanks for your educational videos, very helpful

[@ibrahimshaik1883]

Can you please explain how to count in period of time

[@abdulqadeerkamangar6279]

Based on counts column, can we also able to determine top 5 / 10 counts of specific column?

[@kiran4059]

Do count Function counts the Date data type ?

[@AlvinRyellPrada]

Is there anyway i can count value base on the output from my measures? Let's say the output of my measures are apple and banana From there results... Can i count it?

[@TheHimaBindu]

You need to create another measure to count

[@AlvinRyellPrada]

@@TheHimaBinduis there a way i can reach out to you? :)

[@TheHimaBindu]

You can message me here

[@shivargvfilm1989]

i checked all the video list in your channel.. there is no video on countx and countax... will you plz make it madam.. you're adding great value for my learning...tq

[@TheHimaBindu]

Glad to know that my videos are helping you . Sure will definitely make the topics you requested

[@shivargvfilm1989]

@@TheHimaBindu thank you

[@harshayalemane5313]

Nice explanation, can you also include equivalent of COUNTIF in excel in power bi

[@TheHimaBindu]

Will do

[@chandrakumarv9304]

Very Nice Thanks for sharing mam please upload more videos we are waiting :) Subscribed ,liked and shared :)

[@TheHimaBindu]

Thank you

[@tableaututorialstips71]

@@TheHimaBindu Thanks for your replay mam

[@sahoosujeet1]

please share the data set as well.

[@sudhakarc9941]

Good teaching

[@mohannandyala2364]

Nicely explained......

[@TheHimaBindu]

Thank you

[@jackjohnshei8374]

very usefull

[@subbunaidu301]

How to find out specific value, count of specific value in column

[@saikumarboga3383]

Contains function

[@TheHimaBindu]

Thank you !

[@shivargvfilm1989]

best explanation video so far i have seen on count functions ... thank you so much

[@TheHimaBindu]

Thank you

[@shivargvfilm1989]

@@TheHimaBindu hope u do video in count iterate functions soon... You're welcome...Keep doing the best work

[@Ihatesxhoolsomuxh]

Thank you for your wonderful videos. I need to count the blank rows after two tables (left outer join) are combined and I can't seem to get it right. any advise is appreciated.