Get value from another row in filtered table

[Broly]

Hi,

I have a table that looks like this :

I have applied a bunch of filters on it : status = "a" or "b", date1= between 1 jan 2023 to 31 jan 2023, date2 = 1 jan 2023

and know it looks like this : 

For each ref that I have in the filtered table, I want to know if that ref exist in "c" status in the unfiltered table. 

in this example it would look like this :

I tried to create a measure that counts the number of ref using calculate with "removefilter()" But I keep having duplicate.

How can I write a measure that keeps the filtered table as and tells if the ref exist in the whole unfiltered table ?

Would really appreciate your help thanks

[JirkaZ]

IMHO it could look something like this:

MyMeasure := 
   VAR _CurrentRef = SELECTEDVALUE('MyTable'[ref])
   VAR _Exists = COUNTROWS(FILTER(ALL('MyTable'), 'MyTable'[ref] = _CurrentRef))
RETURN
   IF(_Exists > 0, "Yes", "No")