Count all cells, including the blank fields

[Applicable88]

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. 

[amitchandak]

@Applicable88 , Try Countrows(Table)

Or Countx(Table, Table[Column]+0)

[Applicable88]

thank 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