Forum Discussion
Extract Table from a table based on a criteria
Hey Gurus,
I would like to extract distinct value table from another table based on a criteria.
Extract Distinct Names and Class, excluding Mark X.
Example:
| Class | Name | Mark |
| A | Tina | |
| A | Samy | X |
| A | Tony | |
| B | Lina | |
| B | Fady | X |
| E | Adam | |
| E | Gina | |
| E | Sally | X |
| E | Marina | |
| A | Tina | |
| A | Samy | X |
| A | Tony | |
| B | Lina | |
| B | Fady | |
| E | Adam | |
| E | Gina | |
| E | Sally | X |
| E | Marina |
Hi Anonymous
If I understand it correctly, you can create a new table with below DAX.
New Table = DISTINCT(FILTER('Table', 'Table'[Mark] <> "X"))If you only want Class and Name columns in the new table, try
New Table = SELECTCOLUMNS(DISTINCT(FILTER('Table', 'Table'[Mark] <> "X")),"Class",'Table'[Class],"Name",'Table'[Name])Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
4 Replies
- amitchandak
Super User
Anonymous , New table
calculatetable(Table, Table[MArk] <> "X")
for visual table create a measure and use that with class and name
calculate(countrows(filter(Table, Table[MArk] <> "X"))
PadycosmosSolution Sage
Create a New table with using the following DAX statement and the result is in the table visual. Hope this is what is expected
v-jingzhangCommunity Support
Hi Anonymous
If I understand it correctly, you can create a new table with below DAX.
New Table = DISTINCT(FILTER('Table', 'Table'[Mark] <> "X"))If you only want Class and Name columns in the new table, try
New Table = SELECTCOLUMNS(DISTINCT(FILTER('Table', 'Table'[Mark] <> "X")),"Class",'Table'[Class],"Name",'Table'[Name])Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.- Ashish_Mathur
Hi,
To a Table visual, drag Class and Name. In the Filter pane, provide a blank condition for the Mark column.
