DAX to Freeze the top level hierarchy values in matrix table

[Anonymous]

Hi Team,

I want to freeze the data for top level hierarchy based on slicer selection.
Please find the below screen shot for your reference.

When I select Other Hrs > 0 in the slicer Subcategory values should get hide but for category values should not change it should remain same.
Expected Output

Note: Above data is dummy data only for the example I have provided those screen shots
Thank in advance

[Anonymous]

Hi Team 

Any solution to above issue ? Please help me

[parry2k]

@Anonymous Thanks for replying back. Why it was so hard to reply to it before, I really don't understand that. You have to follow some forum etiquette. I hope others can help you with this and I'm sure you will get the solution soon. Good luck!

[Anonymous]

Sorry about that. I am new here and I need solution very urgent. 

[parry2k]

Take a courage to answer my last reply. Seems like you are unable to provide details about your problem and expecting a solution. Good luck!

[Anonymous]

when I select Other Hrs > 0 then subcategory lines should display only which are having Other Hrs>0 but that should not Impact to the Total values at category level it always display the same total even we are hiding Other Hrs > 0 lines. If you see the sample screen shot you will get what I am trying to Achieve. 
I am trying DAX like below but it's not working.
IF(ISINSCOPE(Table[Category]),CALCULATE(SUM(Total Hrs),REMOVEFILTERS(Table[Other Hrs])),SUM(Total Hrs)
Thanks in advance 

[Anonymous]

@ryan_mayu @DOLEARY85 any thougts on above issue

[parry2k]

@Anonymous Sorry I'm a little lost in what you are trying to achieve. Can you provide a bit more detail?

[parry2k]

@Anonymous you have to change your measure, share what expression you have in the measures and will able to provide the solution.

[Anonymous]

it's just simple measure Sum(Total Hrs), Sum(MTD Hrs) etc. I am seeking help how we can create the measure in this scenario.