PowerBi Column Values into %

[muggydaniel]

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: 

Team	Task	Volumes
Alpha	Mailroom	100
Alpha	Customer Calls	500
Mega	Mailroom	50
Mega	Customer Calls	100
Mega	Outbound Sales	250

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. 

Team	Task	Volume %
Alpha	Mailroom	17%
Alpha	Customer Calls	83%
Mega	Mailroom	13%
Mega	Customer Calls	25%
Mega	Mailroom	63%

[Ahmedx · Accepted solution]

pls try this

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