dynamic select values from the same column to generate scatterplot

[Eyal]

Hi all 

I have the following scenrio:

I a have a single table with multipl colmuns for the diffrent parmater anlysed doring the meny step of a process.

I want to be able to generate a corolation (scatterplot) by dynamic selection, so the user can analys what ever combination he likes.

I genreted a 2nd table (a opy of the first) so i can have 2 no related slicers.
to get the selected value i used this measure :

 

X value = Var Stg= SELECTEDVALUE('Table'[Stage]) VAr STp= SELECTEDVALUE('Table'[Step]) Var SS= SELECTEDVALUE('Table'[Sub-Step]) var ana=SELECTEDVALUE('Table'[Analysis]) var Para=SELECTEDVALUE('Table'[Parameter]) Return CALCULATE( min('Table'[value]), Filter('Table', 'Table'[Stage]=stg && 'Table'[Step]=stp && 'Table'[Sub-Step]=ss && 'Table'[Analysis]=ana && 'Table'[Parameter]=Para) )

Y value = Var Stg= SELECTEDVALUE('Table 2'[Stage]) VAr STp= SELECTEDVALUE('Table 2'[Step]) Var SS= SELECTEDVALUE('Table 2'[Sub-Step]) var ana=SELECTEDVALUE('Table 2'[Analysis]) var Para=SELECTEDVALUE('Table 2'[Parameter]) Return CALCULATE( min('Table'[value]), Filter('Table', 'Table'[Stage]=stg && 'Table'[Step]=stp && 'Table'[Sub-Step]=ss && 'Table'[Analysis]=ana && 'Table'[Parameter]=Para) )

The issue I have is a can not combine the two masures in a single visual.
What am I missing? 

Thank you for your help

[Eyal]

@AlexisOlson  thank you this work great!!

I am couriuse is there a way to get to the same result using just a single table and single slicer with multiple selection? anyone up for the chalenge 🙂 ?

[AlexisOlson]

I'm not sure it's a great idea but you could allow multiple select from a single independent parameter table and use MIN/MAX to separate the selection choices.

[AlexisOlson · Accepted solution]

I'd recommend two independent parameter tables (with no relationships to other tables) for selecting X and Y and then using those two selections to filter a single set of fact and dimension tables. This avoids the problem you have where the Lot1 and Lot2 rows are coming from different tables and thus don't work in a combined visual.