i have the below table called “Skill Selection List”:
| Skill | Level |
|---|---|
| Writing | 1 |
| Writing | 2 |
| Writing | 3 |
| Writing | 4 |
| Reading | 1 |
| Reading | 2 |
| Reading | 3 |
| Reading | 4 |
| Listening | 1 |
| Listening | 2 |
| Listening | 3 |
| Listening | 4 |
| Speaking | 1 |
| Speaking | 2 |
| Speaking | 3 |
| Speaking | 4 |
i have created a slicer with the combination of the two columns from the “Skill Selection List” Table.
i want to create a measure that returns a dynamic table , where if i select, for example, Speaking 3 and Listening 2, the measure will return a table of Speaking 1, 2, 3 and Listening 1, Listening 2