Forum Discussion
Get value from another row in filtered table
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
1 Reply
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")
