Count blanks in a table

[Anonymous]

Hi Experts

I have a FACT sales table and u want to count the total blank and cell that have no data across the entire table. Is this possible using DAX.

[Pragati11]

Hi @Anonymous ,

I don't understand your query completly. 

What do you mean by "cell that have no data across the entire table" ???

Are you referring to the column in a table or row in a table.

Also add somesmaple data and screesnhots to get your query answered properly.

Thanks,

Pragati

[Anonymous]

Hi I am referring to the entire table all columns..if i have 26 column in my table how many blanks to i have in total across the 26 columns.

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Check if the following exusting thread helps:

https://community.powerbi.com/t5/Desktop/countblank-for-20-columns/td-p/120812

Thanks,

Pragati

[Anonymous]

Many thanks