Keeping certain measures for separate slicers

[Anonymous]

How can I attach certain measures to specific departments in my slicer and have the measures stick to that specific department so when i switch to a different one, that measure will still be there from before and i will not have to drag it over each time i want to use it?

I have attached screenshots to provide better understanding (the purple dotted line is the measure that i am using):

[v-shex-msft]

Hi @Anonymous,
You can take a look at the following blog about all functions and add to your expression, then these formulas will only respond with specific field filters:

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT 

Regards,

Xiaoxin Sheng

[MFelix · Accepted solution]

Hi @Anonymous ,

You need to ad an ALL filter to you measure something similar to this:

MEASURE = CALCULATE (SUM(Table[Column]), FILTER(ALL(Table[Department]), Table[Department] = "Department") )