cancel
Showing results for
Did you mean:
Visitor

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

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.

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User

## Re: Measure to divide the sum of one column by the count of another

```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.

Proud to be a Datanaut!

Highlighted
Super User

## Re: Measure to divide the sum of one column by the count of another

```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.