Calculating measure based on specific column

[ExcelMonke]

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 calculate the value of column "division". I have tried 

CALCULATE([Measure],Filter('LocationDim',MAX('LocationDim'[Division]) 

To no avail. Any help is appreciated!

Division	Department	Value
1	a	12
1	b	34
2	c	45
4	d	56

The measure in of itself is a different calculation that shouldn't be affected by this formula (it is a modal calculation - nothing too complex)

[ExcelMonke · Accepted solution]

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])
)

[Ashish_Mathur]

Hi,

Your question is not clear.  Offer a clear explanation and show the expected result.

[ExcelMonke]

Hello, 

You are correct, my apologies. As mentioned my raw data looks like this:

Division	Department	Value
1	a	12
1	b	34
2	c	45
4	d	56

What I would like to do is calculate the division level value for each department. This calculation is already partially done with a seperate measure which calculates the modal value. So effectively, I want to know:

If I am looking at department C, what would the value be of divison 2. I.e.  if I have 5 different departments under division 2 (a,b,c,d,e), how can I calculate the value of the "parent" division for each department. Does that make more sense?

[CoreyP]

Division Total = CALCULATE( SUM( 'Table (2)'[Value] ) , ALLSELECTED( 'Table (2)'[Department] ) )