Forum Discussion
Impactful IndividualCalculating 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 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)
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]) )
4 Replies
- Ashish_Mathur
Super User
Hi,
Your question is not clear. Offer a clear explanation and show the expected result.
ExcelMonkeHello,
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?
CoreyPSolution Sage
Division Total = CALCULATE( SUM( 'Table (2)'[Value] ) , ALLSELECTED( 'Table (2)'[Department] ) )- ExcelMonke
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]) )
