Measure to divide the sum of one column by the count of another

[DaveAA]

Hello,

I have 2 columns - column1 contains unique labels, column2 contains a value (1 or 0 that represents yes/no).  I want to sum the values in column2 and divide by the number of occurrences of the unique label over any rows so I can return a % of Y vs. N.

Ecru Uph	1
Ecru Uph	1
Leesport Uph	1
Arcadia Uph	1
Arcadia Uph	1
Arcadia Uph	1
Arcadia Uph	0

Thank you.

[Anonymous · Accepted solution]

CountAll = COUNTROWS('YourTable')

CountYes = CALCULATE(
	[CountAll],
	'YourTable'[Column2] = 1
)

Yes Percent = DIVIDE(
	[CountYes],
	[CountAll]
)

I've split this up into 3 measures so you can call those measures later on, for example if your wanted a No percent.