Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

0
jcs93

Counting distinct blank from the Visual Values drop down

Submitted by Helper I on ‎05-11-2022 09:55 AM

When setting a value within a visual to Count(DISTINCT), blank cells are counted which skews the total count of values within that column.

 

Although this can be accomplished using DAX DISTINCTCOUNTNOBLANK(), it not always practical to use the DAX measure as it prevents the export of underlying data within the visual.

 

Can the visual value summarization of Count(Distinct) be changed to reflect the DAX function of DISTINCTCOUNTNOBLANK()?  Why would you want to count a blank/empty cell anyway?

Status: Delivered

Currently Count(Distinct) is equal to DISTINCTCOUNT() function which is by design in Power BI Desktop as far as I know.

 

Blank value could also be counted in some senarios, if want to count non blank values, using DISTINCTCOUNTNOBLANK() function is a better choice.

 

In addition, about this feasure in the field, you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas


It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Community Support Team _ Yingjie Li

See more ideas labeled with:
1 Comment (1 New)
Comments
v-yingjl
Community Support
Community Support
‎05-11-2022 07:09 PM
Status changed to: Delivered

Currently Count(Distinct) is equal to DISTINCTCOUNT() function which is by design in Power BI Desktop as far as I know.

 

Blank value could also be counted in some senarios, if want to count non blank values, using DISTINCTCOUNTNOBLANK() function is a better choice.

 

In addition, about this feasure in the field, you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas


It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Community Support Team _ Yingjie Li

Idea Statuses