Channel: WiseOwlTutorials

Category: Education

Tags: countingfree tutorialdistinctcountnoblankonline trainingcountpower bicountxfree trainingmicrosoftbusiness intelligenceonline tutorialcountacountaxpbidistinctcountcountrowsfunctiondaxtutorialwise owl

Description: By Andrew Gould Download files here 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: youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link 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 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!