Forum Discussion
ggzmorsh
Helper II
6 years agoTable from a distinct category
I would like to create a distinct table from Table1
| reference.id | event.id |
| 1 | a |
| 2 | b |
| 3 | c |
| 4 | d |
| 5 | e |
| 6 | a |
| 7 | b |
| 8 | c |
| 9 | d |
| 10 | e |
| 11 | a |
| 12 | b |
| 13 | c |
| 14 | d |
| 15 | e |
And the new Table2 would only give me the event.id that has "a".
| reference.id | event.id |
| 1 | a |
| 6 | a |
| 11 | a |
Hi ggzmorsh
The simplest way with use of New Table DAX expression
Table2 = FILTER( Table1, Table1[event.id] = "a" )Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.