cancel
Showing results for
Search instead for
Did you mean:
Highlighted
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.
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.

## Helpful resources

Announcements

#### Community Highlights

Find out what's new in the Power BI Community!

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 95 members 1,544 guests
Recent signins:
Please welcome our newest community members: