cancel
Showing results for
Did you mean:
Highlighted Post Patron

## 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
Highlighted Community Support

## 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 others find it more quickly.
6 REPLIES 6
Highlighted Resolver IV

## Re: calculate account gp

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

Highlighted Post Patron

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

Highlighted Resolver IV

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

Highlighted Post Patron

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

Highlighted Community Support

## 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 others find it more quickly.
Highlighted Community Support

## 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 others find it more quickly.

Announcements #### Power Platform Community Conference

Check out the on demand sessions that are available now! #### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event. #### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021 #### Get Ready for Power BI Dev Camp 