Forum Discussion
BankJay
3 years agoRegular Visitor
Need to countrows based on two variable characteristics
I have 3 categories of clients (Column 1), each starting with a different number. I need to be able to calculate how many in each category are Blank in Column 2. I have been able to filter to...
vicky_
3 years agoSuper User
Have you looked at the COUNTBLANK function? https://learn.microsoft.com/en-us/dax/countblank-function-dax
BankJay
3 years agoRegular Visitor
Thank you for this reply! That would work, but I'd have to find a way to form that function for each of my Categories, which all appear in Column 1. Any ideas?