title: use selectedvalue in row context calculated column
body: <p>this is a hard question, I have a filter on a standalone table (not connected to tables in my model) I need to retrieve the value from the filter, and calculate a calculated column on another table.</p>
  
  <p>let say that the filter has {selected value} from Table A
  I need this selected value to compute this formula:
  newColumn = IF( TableB:colA = {selected value} then "caseA"
  ELSE IF(TableB:colB = {selected value} then "caseB"
  ELSE "caseElse"</p>
  
  <p>the problem is that in a row context I haven't access to the filter context, so the formula SELECTEDFILTER give me back blank!</p>
  
  <p>How do I compute this?
  many thanks!</p>