Forum Discussion

antel1's avatar
antel1
Frequent Visitor
7 years ago

Make Measure Unaffected By One Particular Slicer

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...
Need Help
antel1's avatar
antel1
Frequent Visitor
7 years ago

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