How to ignore a slicer for one measure but apply it on another

Question

I'm new to power bi and DAX, I am trying to deal with a graph where the X-axis shows the hours of the day. Each bar shows data of a specific location, yet it's possible that two different bars would show the same location because of a time difference (hours on the X-axis). What I'm trying to do is to SUM a column, grouped by location.

Any kind of help would be appreciated.

Answer 1

In order to ignore Slicer you need to ignore the filter context created by that slicer. And to adjust/ignore Filter Context, you need to use the Calculate/Calculate table function.