cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Sum category per zipcode and show percentage of male/female per zipcode

Hi guys,

I have a dataset which contains the following, but i can't seem to get the % of zipcode working.

 Zipcode Gender Number of contacts % of zipcode 10 female 1000 62,5% 10 Male 600 37,5% 20 female 800 66,7% 20 Male 400 33,3%
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Sum category per zipcode and show percentage of male/female per zipcode

Hi @mertzin

Create a measure

```Measure =
CALCULATE (
SUM ( Table1[Number of contacts] ),
ALLEXCEPT ( Table1, Table1[Zipcode], Table1[Gender] )
)
/ CALCULATE (
SUM ( Table1[Number of contacts] ),
ALLEXCEPT ( Table1, Table1[Zipcode] )
)

```

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support Team

## Re: Sum category per zipcode and show percentage of male/female per zipcode

Hi @mertzin

Create a measure

```Measure =
CALCULATE (
SUM ( Table1[Number of contacts] ),
ALLEXCEPT ( Table1, Table1[Zipcode], Table1[Gender] )
)
/ CALCULATE (
SUM ( Table1[Number of contacts] ),
ALLEXCEPT ( Table1, Table1[Zipcode] )
)

```

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Frequent Visitor

## Re: Sum category per zipcode and show percentage of male/female per zipcode

@v-juanli-msft It worked like a charm! Thank you very much!

Announcements

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors