Forum Discussion

mgaut341's avatar
mgaut341
Icon for Helper II rankHelper II
1 year ago
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...
  • mgaut341's avatar
    mgaut341
    1 year ago

    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. 

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi mgaut341,

Please provide sample PBIX file that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? 

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

 

Thank you.