Sum of multiple rows (but not all)

[PoBi]

Hi,

I need a measure to sum all rows related to production only. I have a column with all departments and i want a sum of all departments related to production only. Here is an example of how my table i looking.

so here i would like to have a measure to sum all rows except Wash and Cafeteria. I have tried to filter the visual, but i need a measure so i can use it in calculations 

[ValtteriN · Accepted solution]

Hi,

Here is how to do this:

Sum of some = SUMX(FILTER('Table (20)',not('Table (20)'[Dim]  in {"D","E"})),[Value])

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[PoBi]

Thank you!