cancel
Showing results for
Did you mean:
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
Community Support

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

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.
Community Support

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.
Resolver IV

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

Post Patron

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)

Resolver IV

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)

Post Patron

@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

Announcements