Help. Count all numbers >= 1 as 1

[Legacy 301750]

I'm creating a Dax formula where when I count the rows if the number is 1 or greater than one I get a return values of 1 and 0 is 0.

example

[Net Activations Count](sum)	[Test Activation Count] (count)
1	1
2	1
4	1
0	0

<tbody>
</tbody>

The first column column counts the number records. The "Test Activation Count" counts all records on the Source column but will only return a 1 or 0.

The problem I'm getting is that the functions that I'm generating are a loop and I can't brake the loop.

Any guidance will be helpful

 

[Legacy 301750]

First, Thank you for taking the time.

The product activated is like a store put it on the self. This makes it active. There might be multiple of this product on the shelf but all we care about it that it is active. You can see on the first table, in some cases, that there are multiples on one product active.

On the second table I was able to show that they are active or not Using the formula above but the catch is that it does not total so I Can't get the percentage.

 

[oldbrewer]

	Store Name	Product 1	Product 2	Product 3	Product 5	Total
	store1	1	1	1	1	4
	store2	0	1	1	0	2
	store3	1	1	0	1	3
	total	2	3	2	2	9
	Store Name	Product 1	Product 2	Product 3	Product 5	zeros
	store1	1	1	1	1	0
	store2	0	1	1	0	2
	store3	1	1	0	1	1
	total	2	3	2	2	0
	Store Name	Product 1	Product 2	Product 3	Product 5	%ACT
	store1	1	1	1	1	100	#######
	store2	0	1	1	0	50
	store3	1	1	0	1	75
	total	2	3	2	2	100
	formula in cellmarked ######
	=100*(4-COUNTIF(G31:J31,0))/4

<colgroup><col><col><col span="8"></colgroup><tbody>
</tbody>