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

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

#### ‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors