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 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'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

1 Reply

  • 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