Vertical analysis

[Anonymous]

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?

[RicardoContrera]

I have the same issue!..

[Anonymous]

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

[parry2k]

@Anonymous try this:

Ingresos = 
CALCULATE(
   SUM(ZF01[Dólares  GyP]), 
   FILTER (  
        ALL (  'Tabla posiciones' ), 
        'Tabla posiciones'[Agrupación]="Ingresos de operación, neto" 
   )
)

[parry2k]

@Anonymous can you share the measure expression for income?

[Anonymous]

Ingresos = CALCULATE(SUM(ZF01[Dólares  GyP]), 'Tabla posiciones'[Agrupación]="Ingresos de operación, neto")