How to applying the slicer selected options to UNION tables

[Heedon]

I have data set like below

raw data =  

lot	parameter	value
W101	X1	10
W101	X2	20
W101	X3	30
W101	Y1	12
W101	Y2	29
W101	Y3	39

i composed the raw dataset as Data_X and Data_Y appliying the each X-parameter/Y-parameter slicers (with parameter selection)

when I choosed the X1 and X2 at X-parameter, 

Data_X was applied filter context of slicer with X1 and X2

lot	parameter	value
W101	X1	10
W101	X2	20

when I choosed the Y2 and Y3 at Y-parameter, 

Data_Y was applied filter context of slicer with X2 and X3

I have data set like below

raw data =  

lot	parameter	value
W101	X1	10
W101	X2	20
W101	X3	30
W101	Y1	12
W101	Y2	29
W101	Y3	39

i composed the raw dataset as Data_X and Data_Y appliying the each X-parameter/Y-parameter slicers (with parameter selection)

when I choosed the X1 and X2 at X-parameter, 

Data_X was applied filter context of slicer with X1 and X2

lot	parameter	value
W101	y2	29
W101	y3	29

and I wanna get UNION(DATA_X, DATA_Y) but after applying the filter context with X1 and X2 + Y2+Y3 like below.

How to i get below table that applied the results(parameters set, X parameters and Y parameters) users sellect at the X-parameter and Y-parameter slicer.??

lot	parameter	value
W101	y2	29
W101	X1	10
W101	X2	20
W101	y3	39

[AmiraBedh]

I created a table to gather the slicers Y and you can do the same for X :

SlicerTable_Y = 
DATATABLE(
    "parameter", STRING,
    {
        {"Y1"},
        {"Y2"},
        {"Y3"}
    }
)

Then you create a calculated table :

Data_Y =
CALCULATETABLE(
    raw_data,
    raw_data[parameter] IN VALUES(SlicerTable_Y[parameter])
)

You do the same thing for X and at the end you combine the result of the 2 calculated tables :

Final_Combined_Table =
UNION(Data_X, Data_Y)

[lbendlin]

@AmiraBedh remember that you shouldn't create calculated columns or calculated tables based on slicer values, filters or measures.  The filter context does not apply to calculated items.

[Heedon]

thank you for kind response

I checked the filter context do not applying to calculated items... its sad news....

-->parameter list of UNION(DATA_X, DATA_Y) do not changed by selecting the parameters in Slicer_X / Slicer_Y  

is there any other option to solve the problem? 

[lbendlin]

In your original table why not select X1,X2,Y2 and Y3 ?

[Heedon]

i have to design inducing the users just choose multiple X1,X2, X3, X4  and Y1, Y2, Y3 among X1~X100 and Y1~Y200 at slicers.

then I send the selected dataset that applying the X1,X2,X3,X4, Y1,Y2, Y3 to Python visualization using python script (Regression models). 

I just want the final filter contexted table..

[lbendlin]

Not sure how you get any regression out of these datapoints. Did you mean correlation?

Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.

[Heedon]

lot	parameter	value
W101	X1	1
W102	X1	2
W103	X1	3
W104	X1	4
W101	X2	2
W102	X2	4
W103	X2	6
W104	X2	8
W101	Y1	4
W102	Y1	3
W103	Y1	2
W104	Y1	1
W101	Y2	9
W102	Y2	7
W103	Y2	5
W104	Y2	2
W101	X3	5
W102	X3	6
W103	X3	5
W104	X3	4
W101	Y3	7
W102	Y3	8
W103	Y3	8
W104	Y3	9

the raw data is like this (at real data, the X1 ~X100 and the Y1 ~Y100 exists and W101~W199 lots)

and if users (customers) choose the X1, X2 and Y2 and Y1

then I get linear regression model (X1 and Y2)  and  (X1 and Y1) and (X2 and Y2) and (X2 and Y1)... like this.. 

[lbendlin]

what would be the expected outcome based on the sample data you provided?

[AmiraBedh]

Totally agree with you ! Just being lazy to use PQ 😄