Make Measure Unaffected By One Particular Slicer

[antel1]

Hi,

I'm trying to make a visual that compares a selected user's median times for each category against the median times of all users.

To do this I need to make one measure that is unfiltered by the user slicer and one that is filtered. The latter is easy, but I'm struggling to make a measure unaffected by one slicer but is still filtered by all other slicers on the report page.

Thanks

[antel1]

Update:

So the two measures I'm currently using are:

Total Median Op Time = 
CALCULATE(
    MEDIAN(TotalOpTimes[TotalOpTime]),
    ALL(CaseHistory[CommittedBy])
)

^For unchanging measure

User Median Op Time = MEDIAN(TotalOpTimes[TotalOpTime])

^For the user specific measure

Everything works when the only slicer being modified is the user slicer. However as soon as I apply any other filter, (either through a slicer or by interacting with another visual,) these measures become equal. I'm not sure why this is happening or how to fix it.

Thanks

[v-shex-msft]

Hi @antel1 ,

You can consider to use allexcept function to ignore specific filter effect:
Using ALLEXCEPT versus ALL and VALUES

Regards,

Xiaoxin Sheng