Forum Discussion

ExcelMonke's avatar
ExcelMonke
Icon for Impactful Individual rankImpactful Individual
2 years ago
Solved

Calculating measure based on specific column

I need some assistance calculating a measure for a specific column. I have scoured the forums for an answer but wasn't really able to get what I needed.    In this example, I would like to calculat...
Need Help
  • ExcelMonke's avatar
    ExcelMonke
    2 years ago

    Thanks to those that replied, I found my solution (posting should this be helpful for others). I ended up with:

     

    Group Value =

Calculate(
  [Measure],
    ALLEXCEPT(Table, Table[division],Table[department])
)

     

CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution Sage
2 years ago
Division Total = CALCULATE( SUM( 'Table (2)'[Value] ) , ALLSELECTED( 'Table (2)'[Department] ) )