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

Need Help

2 Replies

  • 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