Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
"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.
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.
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.
"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.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |