% of each row in subtotal

[Anonymous]

Hi guys I need some help.

It's a P&L statement under development. I need to use a table, not a matrix because of the ragged hierarchy as I have a lot of different hierarchy levels.

-I have made in Excel the P&L statement and imported it to Power Bi ;

- The "rubricas" in this excel are linked to "movements" tables and also "accounts" table;

- I have a table with all account movements (let's call the table "movements");

-I have measures to calculate some total ( for example: "Total Revenue" and "Sub-Total Salaries")

- the measures are all similar: (example for "Total Revenue"    Total Sales =calculate(sum(movement[vales], movement[rubric] in {1002,1002,10031004,1005,1006,1007,1099}), and only changing the "rubricas" to the ones I need to SUM for each measure.

After creating the measures of the totals, i need to apply to each row the respective value. For example, for rubrica 1001, it should present the result of total sales filtered for rubrica 1001 and so on... For the "rubrica " 10001, it should present the inicial total sales

to do this i have made a measure "values" that calculates the correct vale for each rubrica.

This is all working.

Now the issue:

I need a new collum to present for each "rubrica" the % of his weight in the total sales. But not also for the revenue... i need this measure to do this calculations for each "rubrica", not only fror the ones from Revenue group.

My idea is a mesaure something like this:

% On Total Revenue = [total sales] / calculate([total sales],movement[rubrica] in { 1001,1002,1003,1004,1005,1006,1007,1009})

so what i realy need is the second part of this measure, something that calculates the total sales of all that "rubricas" and doesn't changes with any filter or rubricas.

Thank you