cancel
Showing results for
Did you mean:
Member

## calculate account gp

 account code company amount 11999 0 10 15999 0 5 53999 0 75 56999 0 55 58999 0 566 69999 0 74 76999 0 54 11999 1 456 15999 1 2545 53999 1 445 56999 1 4545 58999 1 4456 69999 1 45 76999 1 45

given this table with account code company and amount

, i want be able to calculate for example for each company

the measure of account code 15999/58999

how i can do that?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: calculate account gp

Hi @snifer,

To create a measure as below.

```Measure =
VAR sum2 =
CALCULATE (
SUM ( Table1[amount] ),
FILTER ( Table1, Table1[account code] = 15999 )
)
VAR sum1 =
CALCULATE (
SUM ( Table1[amount] ),
FILTER ( Table1, Table1[account code] = 58999 )
)
RETURN
sum2 / sum1
```

For more details, please check the pbix as attached.

Regards,

Frank

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

## Re: calculate account gp

Is there a relation between account codes, or you want to specifically calculate the values for 15999/58999, please elaborate

Member

## Re: calculate account gp

I need to calculate the amount associated to account code 15999 / amount associate with 58999 associated to company 1 (456/4456)

I need to calculate the amount associated to account code 15999 / amount associate with 58999 associated to company 0 (10/566)

Member

## Re: calculate account gp

you can create a measure like:

Measure0 = divide(

calculate(sum(accounts[amount]),accounts[account code] = 15999, accounts[company] = 0),
calculate(sum(accounts[amount]),accounts[account code] = 58999, accounts[company] = 0),
0)

Measure1 = divide(

calculate(sum(accounts[amount]),accounts[account code] = 15999, accounts[company] = 1),
calculate(sum(accounts[amount]),accounts[account code] = 58999, accounts[company] = 1),
0)

Member

## Re: calculate account gp

@yelsherif

on the example i put just 2 companies but i got more than 50 soi need measure to calculate for each company, making a measure for each company its not gonna work

Community Support Team

## Re: calculate account gp

Hi @snifer,

To create a measure as below.

```Measure =
VAR sum2 =
CALCULATE (
SUM ( Table1[amount] ),
FILTER ( Table1, Table1[account code] = 15999 )
)
VAR sum1 =
CALCULATE (
SUM ( Table1[amount] ),
FILTER ( Table1, Table1[account code] = 58999 )
)
RETURN
sum2 / sum1
```

For more details, please check the pbix as attached.

Regards,

Frank

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

## Re: calculate account gp

Hi @snifer ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Regards,
Frank

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

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 126 members 1,659 guests
Recent signins: