If any column has combination of 1 and 0 then i dont want the count but if it has only 0 then i want to count that

Question & Answer
,
1

suppose column a has value of 10 and 20 and column b has 1 and 0
|a|b|
|10|0|
|20|0|
|20|1|
now i want to count of column a where b = 0 but it will count both 10 and 20 because both has 0 but i want only 10 to be count because 20 has both combination of 0 and 1 so where ever it has combination of 0 and 1 of any value i dont want to count.
can someone please help me with this thank you.

2

Hi @Deepak1
You could sum b for each a and countif the sum(b) is 0.

sum(b,[a])

countif((a),sum(b,[a])=0)

BR

3

Hello Erik,

Thank you for responding,

image
image765×47 2.15 KB

I am getting this error can you please look into this.

4

and also I want to use this in KPI as distinct count which will give output as 1.

5

Hello @Deepak1 and @ErikG !

@Deepak1 Were you able to find a solution for this or was @ErikG 's suggestion helpful?

I would also suggest trying and ifelse statement:

ifelse(
{b} = 0, 
distinct_count({a}, 
Null)
6

Hello @Deepak1 !

Were you able to try my suggestion above or were you able to solve this? It has been some time since we heard from you but would still like to help you find a solution.

If we do not hear from you in 4 days this topic will be archived.