Could you please provide the workbook (.twbx) with some sample so I can try from my end.
You will never be able to apply table calcs across worksheets in a filter or otherwsie. Table calcs are specific to a worksheet because by definition they are defined against the level of detail in the view/worksheet. As such they cannot be applied as a filter to other worksheets. I hope this helps.
Thank you for the replies.
I got it working by using a Parameter and a Binary calculated field.