Forum Discussion

ggzmorsh's avatar
ggzmorsh
Icon for Helper II rankHelper II
6 years ago
Solved

Table from a distinct category

I would like to create a distinct table from Table1

 

reference.idevent.id
1a
2b
3c
4d
5e
6a
7b
8c
9d
10e
11a
12b
13c
14d
15e

 

And the new Table2 would only give me the event.id that has "a".

reference.idevent.id
1a
6a
11a
  • 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.



1 Reply

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion

    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.