How to Use the Power BI DAX function DISTINCTCOUNTNOBLANK

In this article, we will explore the different aspects of the DISTINCTCOUNTNOBLANK function, its syntax, and how you can use it in your Power BI reports.

Understanding the DISTINCTCOUNTNOBLANK Function

The DISTINCTCOUNTNOBLANK function is a variation of the DISTINCTCOUNT function in DAX. While the DISTINCTCOUNT function counts the number of distinct values in a column, the DISTINCTCOUNTNOBLANK function counts only the distinct and non-blank values.

This function is particularly useful in scenarios where you want to ignore the blank values in a column and count only the meaningful data. For example, if you are analyzing sales data and want to count the number of distinct customers who made a purchase, you can use the DISTINCTCOUNTNOBLANK function to exclude any blank values in the customer column.


The syntax of the DISTINCTCOUNTNOBLANK function is as follows:


The ❰column❱ parameter represents the column that you want to count the distinct and non-blank values from.

Using the DISTINCTCOUNTNOBLANK Function in Power BI

To use the DISTINCTCOUNTNOBLANK function in Power BI, you need to follow these steps:

1. Open Power BI Desktop and create a new report.

2. Import your data into Power BI and add it to the report.

3. Create a new measure by clicking on the “New Measure” button in the “Home” tab of the “Ribbon” menu.

4. In the “Formula bar” section, type the following formula:

DistinctCountNoBlank = DISTINCTCOUNTNOBLANK(❰column❱)

Replace ❰column❱ with the name of the column that you want to count the distinct and non-blank values from.

5. Press “Enter” to create the new measure.

Once you have created the new measure, you can add it to your visualizations and start analyzing your data.

The Power BI DAX function DISTINCTCOUNTNOBLANK is a powerful tool that can help you count the number of distinct and non-blank values in a column. By providing a quick and easy way to analyze data, this function can help you make informed business decisions and generate insights that can drive your organization forward.

By following the steps outlined in this article, you can easily use the DISTINCTCOUNTNOBLANK function in your Power BI reports and start unlocking the full potential of your data.

Power BI DAX Training Courses by G Com Solutions (0800 998 9248)

Upcoming Courses

Contact Us


    Your Name (required)


    Email (required)


    Training Course(s)

    Your Message

    Upload Example Document(s) (Zip multiple files)