Forum Discussion

muggydaniel's avatar
muggydaniel
New Member
3 years ago
Solved

PowerBi Column Values into %

Hi all 

 

I am attempting to display collumn values much like a pivottable "show values as % of collumn total" depending on if the rows are the same inside power query

 

For example: 

 

TeamTaskVolumes
Alpha Mailroom100
AlphaCustomer Calls500
MegaMailroom50
MegaCustomer Calls100
MegaOutbound Sales250

 

I would need to transform into the below table where the % of volumes for each team would sum to be 100% and each task has the appropiate % of volume complete out of everything they received. 

 

TeamTaskVolume %
AlphaMailroom17%
AlphaCustomer Calls83%
MegaMailroom13%
MegaCustomer Calls25%
MegaMailroom63%
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

    Measure = 
     DIVIDE(
       SUM('Table'[Volumes]),
          CALCULATE(SUM('Table'[Volumes]),ALLEXCEPT('Table','Table'[Team]))
)

1 Reply

  • Ahmedx's avatar
    Ahmedx
    Super User
    3 years ago

    pls try this

    Measure = 
     DIVIDE(
       SUM('Table'[Volumes]),
          CALCULATE(SUM('Table'[Volumes]),ALLEXCEPT('Table','Table'[Team]))
)