Forum Discussion
Impactful IndividualCount all cells, including the blank fields
Hello,
I want to create a table visual with values from two different tables. One is the Shelftable on the one side and the n-table with all orders. My problem lies in the count of blank fields:
Powerbi does not count the blank fields:
I can only see the fields because I checked "Show empty values".
The count I want is 13? And is there a version for distinct count and all counts?
Thank you very much in advance.
Best.
3 Replies
- amitchandak
Super User
Applicable88thank you for the quick response amitchandak , but both don't work:
isn't "+0" only for displaying values as 0 instead of leaving it empty? But my problem that it should count that cell as well. I think the problem is in fact due to the field is empty and from another table, where it has no value instead of a simple empty field in the same table.
Hope there is a solution to that.
Best.
- amitchandak
Applicable88 , Total 11 is already the correct sum. Do want add 1 for each blank. Then what is causing a blank should be know
Sum(Table,coalesce([value],1))
But the help when value is blank
