Forum Discussion
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...
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]) )
Hi,
Your question is not clear. Offer a clear explanation and show the expected result.
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?