Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Creating a count blank measure taking into account multiple object at once

Hey there. I am new to PowerBI and have been trying to create a function which would count the blanks in a range of columns to see how many data points are missing for each object. We are dealing wit...
Need Help
Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous ,
Please try this and then you may sum the values:

Countblank if any are blank = IF(MAX(Tableblank[Address])="" || MAX(Tableblank[Email]) =""|| MAX(Tableblank[Phone])="",1,0)

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Wow thank you, this really helped! As a follow up quastion, what do I do if some of the values are integers and some are strings?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Actually nevermind, I've converted all my columns to strings but it's just giving me 1 for all the answers, not sure why.