AllExcept function

[Tlotly]

Good day

I have a matrixbelow. When I select a zone on a slicer for example (Chris Hani), I don't want the region details to change. 

Meaning if I put in more levels onto the matrix, the upper level should not change when I filter lower levels.  Is this possible to achieve? I've been searching on the internet and cannot find similar issues.

I tried creating a measure using AllExcept but I'm not getting desired results. The measure does not even give me the correct results.

correct measure:  CALCULATE(count('Drop-Out details'[retention_status]))

correct matrix:

With AllExcept measure: 

var _nonfilter = CALCULATE(count('Drop-Out details'[retention_status]),

ALLEXCEPT ('Drop-Out details','Drop-Out details'[region_description],'Drop-Out details'[zone_description]))

var _normal = CALCULATE(count('Drop-Out details'[retention_status]))

return

if(SELECTEDVALUE('Drop-Out details'[zone_description]) <> BLANK() , _nonfilter, _normal)

before zone filter

zone filter

after zone filter

Thank you in advance.

[Mahesh0016]

@Tlotly please try below code
Measures =
VAR _nonfilter =
CALCULATE (
COUNT ( 'Drop-Out details'[retention_status] ),
ALL (
'Drop-Out details'[region_description],
'Drop-Out details'[zone_description]
)
)
VAR _normal =
CALCULATE ( COUNT ( 'Drop-Out details'[retention_status] ) )
RETURN
IF ( ISINSCOPE ( 'Drop-Out details'[zone_description] ), _nonfilter, _normal )


@Tlotly If this post helps, then please consider Accept it as the solution and kudos to help the other members find it more quickly. 

@Tlotly THANK YOU!!

[Tlotly]

@Mahesh0016 thank you. It still doesn't work. Maybe I have to make separate datasets by region, zone etc..