Filtering without impacting % on total

[afree]

Hi,

I am trying to calculate % of total hours by hour for 4 different regions. I only want to focus on 5am to 7am and 10pm to 11pm. However, when I filter out the other hours, the % of total hours for 5am (for example) skyrockets because there are less hours to base the total on. 

How can I filter out specific hours without impacting the total? 

OR How can I "focus" the matrix on a specific amount of hours and hide the other columns?

Thank you so much!

[CoreyP]

Can you share some sample data and your measure? And what your desired result should look like? My initial reaction is you likely need to remove context in your measure by using ALL or ALLSELECTED, but can't be sure without knowing more. 

[afree]

Of course - thank you for replying. See below for my matrix. 

Current: Right now, I have all hours in the day and the percent of employee hours lets say for each hour. For the values, I have a % of the total hours in a day. That is what I want to capture - However, I only want to look at specific hours in the day. 

Ideal view: I would like to only see the hours 4am - 6am and 10pm to 11pm. However, When I filter those in the visualization, you can see that the % of actual hours inflates.