From the course: Power BI Data Modeling with DAX
Unlock the full course today
Join today to access over 24,600 courses taught by industry experts.
Check your data with COUNTBLANK - Power BI Tutorial
From the course: Power BI Data Modeling with DAX
Check your data with COUNTBLANK
- [Instructor] The Contoso Sales sample database is annoyingly complete. We don't have blanks, there aren't places where a user forgot to fill in a discount, or someone left a field empty because they didn't have the information, and then that moment passed them by. But these are things that happen in real businesses, and it's not unusual that we need to check a data set to see if we have blanks. Let's take a look at how we would do that. I'm going to choose the product table, and let's imagine that sometimes no one fills in a className. If I want to know if that's something that really could happen, I could go to the product table, but you'll notice that the className, like everything else, is filled in. Let's create the measure here, nonetheless. I'm going to create a new measure, and the new measure is going to be called, no class, and that equals, count blank. And we will specify a column. We're going to specify…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Create a measure with SUM2m 47s
-
(Locked)
Understanding DAX syntax1m 51s
-
(Locked)
Display the measure in a matrix1m 15s
-
(Locked)
Format a measure1m 33s
-
(Locked)
Create measures with COUNT and COUNTROWS3m 23s
-
(Locked)
Delete or edit a measure4m 29s
-
(Locked)
Check your data with COUNTBLANK1m 36s
-
(Locked)
Create a measure with DISTINCTCOUNT2m 28s
-
(Locked)
-
-
-
-