Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Count blanks in a table

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
5 years ago
Hi Anonymous ,

Check if the following exusting thread helps:

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

Thanks,

Pragati

4 Replies

Pragati11
Super User
5 years ago
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
  Not applicable
  5 years ago
  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
    Super User
    5 years ago
    Hi Anonymous ,
    
    Check if the following exusting thread helps:
    
    https://community.powerbi.com/t5/Desktop/countblank-for-20-columns/td-p/120812
    
    Thanks,
    
    Pragati