Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0

Counting distinct blank from the Visual Values drop down

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

Comments
v-yingjl
Community Support
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