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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
carpegc
Frequent Visitor

Distinct count of blank values in visual

I'm trying to count distinct blank cell in visual table. I have tried this 

DISTINCTCOUNTNOBLANK('STOs Visibility'[Planned ETA])+COUNTBLANK('STOs Visibility'[Planned ETA])

But it doesn't seem to count distinct values. Any help is much appreciated. 

1 ACCEPTED SOLUTION
daXtreme
Solution Sage
Solution Sage

"I'm trying to count distinct blank cell in visual table."

 

Hm... interesting. As far as I know, there's only one type of BLANK in DAX, so the answer will always be... 0 or 1. Two BLANKS are equal, so.... you can't have more than 1 distinct blank cell.

View solution in original post

4 REPLIES 4
v-yinliw-msft
Community Support
Community Support

Hi @carpegc ,

 

I am a little confused, what do you mean the distinct blank cell?

You mean “” or there is nothing in the cell?

Or you just want to know the numbers of all the blank cells in a table?

 

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

carpegc
Frequent Visitor

Is there another method of counting distinct blank values? I count dictinct value when a value is present, but want to count the blank that are distinct. 

 

Once again... There are no different distinct blank values. You cannot distinguish among blanks.

daXtreme
Solution Sage
Solution Sage

"I'm trying to count distinct blank cell in visual table."

 

Hm... interesting. As far as I know, there's only one type of BLANK in DAX, so the answer will always be... 0 or 1. Two BLANKS are equal, so.... you can't have more than 1 distinct blank cell.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.