cancel
Showing results for
Did you mean:
Regular 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

## 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

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

Regular 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

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors