Forum Discussion

BankJay's avatar
BankJay
Regular Visitor
3 years ago

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...
"DAX"
blank
COUNTROWS
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  BankJay ,

I created some data:

Here are the steps you can follow：

1. Create calculated column.

Column =
COUNTX(
    FILTER(ALL('Table'),
    'Table'[Column1]=EARLIER('Table'[Column1])&&'Table'[Column2]=BLANK()),[Column1])

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • BankJay's avatar
    BankJay
    Regular Visitor
    3 years ago

    Thank you, but I'm not sure if that quite gets to what I need. In your example (thank you for creating data!) I would need one additional step I think. I would need to calculate a measure for Category 123, Category 234, and Category 345 that just tells me the total blanks. 

     

    Is there an easy way to combine that with what you have shown?