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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors