DAX Fridays! #4: COUNT, COUNTA, COUNTX, COUNTAX, DISTINCTCOUNT AND COUNTROWS in DAX
Let's go through all the count expressions available in DAX!
Here you have the keynotes for the video so you can jump to the function you want to learn:
02:44 COUNT text (#ERROR)
03:24 COUNT numbers
04:20 COUNT blanks
04:56 COUNT dates
05:36 COUNTA text
06:44 COUNTA numbers
07:27 COUNTX
09:16 COUNTAX
09:58 DISTINCTCOUNT
10:59 COUNTROWS(DISTINCT)
12:06 COUNTBLANK
12:34 COUNTROWS
13:32 COUNTROWS with columns (#ERROR)
14:33 COUNTROWS with an expression
Link to Curbal Glossary: https://curbal.com/blog/glossary/COUN...
PREVIOUS VIDEO: • DAX Fridays! #3: SUM and SUMX
NEXT VIDEO: • DAX Fridays! #5: CALCULATE (Part 1)
Dowload the sample file here:
https://curbal.com/blog/glossary/coun...
Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB
► Linkedin: https://goo.gl/3VW6Ky
#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP
