Filters are used to eliminate data from the view - suggest you look at using sets to separate the data into 2 groups - sets do not filter data out just put the data into an IN and an OUT group based on a criterion - all the data are still there - you can then use the set to separate, color or in other calculations
If you provide the twbx workbook I would give you the actual formula
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.