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

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…

Contents