Could someone advise if this is possible.
I am trying to change the x & y on a scatter graph using measures in the table below.
My thoughts are if a selection is made using the DAX measure below it changes the X axis on a scatter chart, this seems to work.
The next step would be to do the same thing with the y but this keeps hold of the filter for X.
Selection X = SWITCH(TRUE(),
HASONEFILTER('Assessment'[Subject (Collection Point)]),CALCULATE(AVERAGE(' Assessment'[Result]),ALLEXCEPT('Assessment','Assessment'[Subject (Collection Point)]))
)
Assessment
| ID | Subject (Collection Point) | Result |
| 1 | Mathematics (1) | 6 |
| 2 | Mathematics (1) | 5 |
| 3 | Mathematics (1) | 3 |
| 4 | Mathematics (1) | 4 |
| 5 | Mathematics (1) | 4 |
| 6 | Mathematics (1) | 3 |
| 7 | Mathematics (1) | 3 |
| 8 | Mathematics (1) | 6 |
| 9 | Mathematics (1) | 2 |
| 10 | Mathematics (1) | 6 |
| 11 | Mathematics (1) | 6 |
| 12 | Mathematics (1) | 5 |
| 13 | Mathematics (1) | 2 |
| 1 | Mathematics (2) | 4 |
| 2 | Mathematics (2) | 4 |
| 3 | Mathematics (2) | 5 |
| 4 | Mathematics (2) | 6 |
| 5 | Mathematics (2) | 7 |
| 6 | Mathematics (2) | 8 |
| 7 | Mathematics (2) | 9 |
| 8 | Mathematics (2) | 6 |
| 9 | Mathematics (2) | 9 |
| 10 | Mathematics (2) | 4 |
| 11 | Mathematics (2) | 8 |
| 12 | Mathematics (2) | 9 |
| 13 | Mathematics (2) | 8 |
| 1 | Reading (1) | 6 |
| 2 | Reading (1) | 5 |
| 3 | Reading (1) | 3 |
| 4 | Reading (1) | 4 |
| 5 | Reading (1) | 4 |
| 6 | Reading (1) | 3 |
| 7 | Reading (1) | 3 |
| 8 | Reading (1) | 6 |
| 9 | Reading (1) | 2 |
| 10 | Reading (1) | 6 |
| 11 | Reading (1) | 6 |
| 12 | Reading (1) | 5 |
| 13 | Reading (1) | 2 |
| 1 | Reading (2) | 4 |
| 2 | Reading (2) | 4 |
| 3 | Reading (2) | 5 |
| 4 | Reading (2) | 6 |
| 5 | Reading (2) | 7 |
| 6 | Reading (2) | 8 |
| 7 | Reading (2) | 9 |
| 8 | Reading (2) | 6 |
| 9 | Reading (2) | 9 |
| 10 | Reading (2) | 4 |
| 11 | Reading (2) | 8 |
| 12 | Reading (2) | 9 |
| 13 | Reading (2) | 8 |
