cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cloud11
Post Patron
Post Patron

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.

 

1 ACCEPTED SOLUTION

Hi @Cloud11 ,

 

Check if the following exusting thread helps:

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

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

4 REPLIES 4
Pragati11
Super User III
Super User III

Hi @Cloud11 ,

 

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





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




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.

Hi @Cloud11 ,

 

Check if the following exusting thread helps:

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

 

Thanks,

Pragati





If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

Many thanks

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors