Transpose '% of row' DAX formula to '% of column'

[ronnoc]

Hi there, first post and new user of powerBI. Screenshots are of pivot tables in excel I am recreating in PowerBI.

I need help transposing my current formula for calculating the % of row total (working here in table 1):

 

% = SUM(ttData[USD Media Spend]) / CALCULATE(SUM(ttData[USD Media Spend]),ALLSELECTED(ttData[G2 Media Type]))

I now need to calculate the column total as seen here:

Here is my current formula: 

% = DIVIDE (
SUM(ttData[USD Media Spend]),
CALCULATE (
SUM(ttData[USD Media Spend]),
ALLSELECTED(ttData[Year])))

Of which the outcome is this:

Its obviously not quite right! Any help is appreciated. Very new to DAX. Thank you.

[mmanwaring · Accepted solution]

Hi

Instead of allselected for the year i think you need media type

Mike