Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Pivot Table/Power Query DAX Formula

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 th...
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    Anonymous , Try using below DAX

     

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

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

Anonymous , Try using below DAX

 

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