By Andrew Gould

Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-count/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

This video shows you a variety of ways to count things in DAX. You'll learn how to count values in a column using the COUNT and COUNTA functions, and what effect blanks have on the result of the count. You'll see how to use the COUNTROWS function to avoid issues caused by blanks and how to count unique values using the DISTINCTCOUNT and DISTINCTCOUNTNOBLANK functions. Finally, you'll learn how to count the result of an expression using the COUNTX and COUNTAX functions, as well as how to combine these with the IF function to create a rudimentary Count If setup.

Chapters
00:00 Topic list
00:35 Importing Data
01:16 Counting Numbers, Text and Dates
03:39 Counting Boolean Values
05:32 Counting and Blanks
06:33 Counting Rows
08:36 Counting Distinct Values
09:32 Counting Distinct Non Blank Values
11:31 Counting the Results of a Calculation
14:35 Creating a Basic Count If Measure

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!