Calculated budget % share row (calculated row?)

[CloudMonkey]

Hi,

I have a pretty normal matrix layout below. But I need to add a budget (without regional or branch splits) to row 10 and a % variance versus budget row in row 11. Please can you tell me how to do this in Power BI?

Thanks for your help,

CM

[CloudMonkey]

Does my question make sense?

[CloudMonkey]

If it's impossible to do this please can someone confirm? How about if I create table 2 below, is this possible? Can I create calculated rows in a table like this (rather than calculated columns?)?

Thanks for any help,

CM

[Anonymous · Accepted solution]

Hi @CloudMonkey,

You can refer to below sample if it suitable for your requirement.

Tables:

Table formula:

SummaryTable = UNION(FirstTable,SecondTable,SELECTCOLUMNS(SUMMARIZE(FirstTable,FirstTable[Month],"Value",SUM(FirstTable[Value])),"Region","Summary","Branch","Total","Month",[Month],"Value",[Value]))

Regards,

Xiaoxin Sheng