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:    Team...
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]))
)
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]))
)