Forum Discussion
Solved
Counting blank fields based on another column
I am trying to count how many blank cells I have in my 'status' column when my 'appt date/time' field has a value in the cell. I have tried the following formula CALCULATE(COUNT('CCHHS Imaging & Pr...
I was not able to get it to work, so I used a subtraction formula from the other result status' to get my correct answer.
Hi mgaut341,
checking in to see if your issue has been resolved. And share the sample data or Pbix file.
Please let us know if you still need assistance.
Thank you.
I was not able to get it to work, so I used a subtraction formula from the other result status' to get my correct answer.
Hi mgaut341,
Glad your issue has been resolved. Please mark your reply as the solution, as it will help other community members.
Thank you.