Calculating percentage over date level

[Gpera]

Hi,

As you can see I have a table with these data:

Share of Voice has been calculated as: 

divide('Adspend - Monthly data'[Spend ('000 Euro)], 'Adspend - Monthly data'[Total Category Spend ('000 Euro)])

But if i create another matrix just for years I get this results:

What I would like to have is a mesure that calculate correctly the percentage on column added, so sum of Spend over sum of Category by each level of granularity. 

Ex.  In Table 1:

2022 | 1 | 1010 | 2816 | 36%

Ex. In Table 2:

2022 | 6596 | 77913 | 8,4%

Could you please help me?

Thanks

[DataInsights · Accepted solution]

@Gpera,

Try these measures. Percentages need to be calculated in a measure, not a column in the table; this allows them to dynamically calculate in the filter context of the visual.

Sum of Spend = SUM ( Spend[Spend] )

Sum of Total Category Spend = SUM ( Spend[Total Category Spend] )

Share of Voice = DIVIDE ( [Sum of Spend], [Sum of Total Category Spend] )