How to use multiple filter scheme in data function

I have a data table, say: ID, Name, State, Gender and 2 filter schemes : State is with filter scheme 1 and Gender is with filter scheme 2

For the table, I can limit data using both filter schemes at the same time.

I create a data function with the input is the data table, and output is a subset of the data table, depending on whatever filters selected.

However, data function input parameter does not allow to select both filter schemes: i.e. either scheme 1 or scheme 2.

So let say if I limit data in data function using scheme 1 then whatever users select Gender for filter, input data to data function is only limited by state.

Attached is the demo. 

Any suggest to overcome this?




Binary Data example.dxp646.77 KB