cancel
Showing results for
Did you mean:
Helper II

## Calculate percentage on subgroup

Hi,

I want to calculate the percentage of each category under each department.

The total for the Asia Pacific department is £449.70, but what is the percentage for each category?

So for Asia Pacific: Transport would be around 54.4%, Subsistence 44.95% and Phone 0.6%

Any help appreciated 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV

## Re: Calculate percentage on subgroup

@wenners68 well then in original measure, change table reference to your department table and it will work

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

6 REPLIES 6
Super User IV

## Re: Calculate percentage on subgroup

@wenners68 here is the measure, change table and column name as per your model

```% = DIVIDE(
SUM( 'Table'[Amount] ),
CALCULATE( SUM( 'Table'[Amount] ),
ALLEXCEPT( 'Table', 'Table'[Department] ) )
)```

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helper II

## Re: Calculate percentage on subgroup

Hi,

That gives you a percentage of 100% for each item...

Department is in one table and category and amount is in another table.

Super User IV

## Re: Calculate percentage on subgroup

@wenners68 I guess you have relationship between department and other table? You never mentioned this in your original post. Read this post to get your answer quickly.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Highlighted
Helper II

## Re: Calculate percentage on subgroup

Yes, there's a relationship between department and category.

Super User IV

## Re: Calculate percentage on subgroup

@wenners68 well then in original measure, change table reference to your department table and it will work

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helper II

## Re: Calculate percentage on subgroup

Thanks, that works 🙂

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