Pivot Table/Power Query DAX Formula

[Anonymous]

I've looked this one up and know it will be some sort of divide function, but I am having trouble getting a measure to fit in when writing it. Below I would need each instance of the row labels in the Bridge Column divided by the total actuals (2.1) in a percentage. Once again, I assume this is easier than it appears, but I cannot get the formula to work for me. Thanks!

[bhanu_gautam · Accepted solution]

@Anonymous , Try using below DAX

Percentage of Total =
DIVIDE(
SUM('YourTable'[Bridge Column]),
CALCULATE(SUM('YourTable'[Bridge Column]), ALL('YourTable'))
) * 100