Forum Discussion
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...
Hi BankJay ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
It would be better if the expected results were shown in the form of pictures.
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
Here is an example. So here, I need to know how many blanks in "Name" for each ID category starting with a different number. For example, for "ID" starting with "5" how many blanks. For "ID" starting with "8" how many blanks. For "ID" starting with "9" how many blanks.