Probably a really dim question about row context on matrix

[masplin]

I have 2 measures

Call Count = CALCULATE(COUNTROWS('S&R Data'),'S&R Data'[TRN_LATEST]=1)

Call Count 2 = CALCULATE(COUNTROWS('S&R Data'),'S&R Data'[TRN_LATEST]=1,CallStatus[Call Group]<>"Not Counted")

the matrix looks like this which is what I expect

However if I now apply a visual filter using filter panel so Call Group = complete I see this which wasn't what i was expecting.   Seems the filter being applied isn't being applied in the total row, but is that because my measure is somehow overriding it with the <>"Not Counted" filter? 

Sure this is DAX 101 so any help appreciated

Mike

[masplin]

Duh. Worked it out. Using FILTER retians the context from the visiual

Call Count 2 = CALCULATE(COUNTROWS('S&R Data'),

FILTER(

'S&R Data',

'S&R Data'[TRN_LATEST]=1 &&

RELATED(CallStatus[Call Group])<>"Not Counted"

)

)