Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Vertical analysis

Hello 

 

I am building the financial statements in power bi. and I want to put a vertical analysis column of the income statement groups (income, costs). These groups are made up of accounting accounts, for example account 1, 2 and 3 correspond to income. What I want to do is divide each group by the income. The measure I have is Amount for the balances of the accounts that make up the groups and I have a measure that calculates the income. When I do the vertical relationship, it is divided by 0, and I can't get it to be divided by the income.

 

 

I need each row to be divided by income (Ingresos).

 

 

 

How can I do this?

Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    Anonymous try this:

     

    Ingresos = 
CALCULATE(
   SUM(ZF01[Dólares  GyP]), 
   FILTER (  
        ALL (  'Tabla posiciones' ), 
        'Tabla posiciones'[Agrupación]="Ingresos de operación, neto" 
   )
)
  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    Anonymous can you share the measure expression for income?

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago
      Ingresos = CALCULATE(SUM(ZF01[Dólares  GyP]), 'Tabla posiciones'[Agrupación]="Ingresos de operación, neto")
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    May I ask if your problem has been solved. If the above reply was helpful, you may consider marking it as solution. If the problem is not yet solved, please feel free to ask us a question.

     

    Best Regards,

    Ada Wang