Forum Discussion

ExcelMonke's avatar
ExcelMonke
Impactful 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])
)

     

ExcelMonke's avatar
ExcelMonke
Impactful Individual
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])
)