Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ExcelMonke
Super User
Super User

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

 

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

To no avail. Any help is appreciated!

DivisionDepartmentValue
1a

12

1b34
2c45
4d56

 

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)





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





1 ACCEPTED SOLUTION
ExcelMonke
Super User
Super User

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

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

4 REPLIES 4
ExcelMonke
Super User
Super User

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

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hello, 

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

DivisionDepartmentValue
1a

12

1b34
2c45
4d56

 

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





CoreyP
Solution Sage
Solution Sage

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.