Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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)

yelsherif's avatar
yelsherif
Icon for Resolver IV rankResolver IV
7 years ago

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)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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