Forum Discussion
Filter unique values from the table
I wanted to create a measure to filter only the unique values from the below table as there are repeated information in the table.
As an example result should only show Product WW & Mark Y only once.
| Product | Mark |
| WW | Y |
| WW | Y |
| WW | O |
| WW | O |
| KK | Y |
| KK | Y |
| KK | Y |
| KK | Y |
| KK | W |
| WW | E |
| WW | E |
| TT | R |
| TT | R |
| TT | R |
| TT | R |
| PP | M |
| PP | M |
| PP | N |
gauravnarchal - Use
Measure = CONCATENATEX(DISTINCT(SELECTCOLUMNS('Table',"Product",[Product])),[Product],",")gauravnarchal It's the default or are you trying to create a new table? Both are set to Don't summarize.
4 Replies
gauravnarchal - Use
Measure = CONCATENATEX(DISTINCT(SELECTCOLUMNS('Table',"Product",[Product])),[Product],",")Hi Greg_Deckler - I am getting the results as below.
Only thing is that all products are showing together which has the same mark.
I need to show the result as Individually. The measure which i used is
Unique = CONCATENATEX(DISTINCT(SELECTCOLUMNS('Database',"Product",[Product])),[Product],",")gauravnarchal It's the default or are you trying to create a new table? Both are set to Don't summarize.
gauravnarchal , if you put them in table visual they will show as distinct values only
measure like
measure =countx(summarize(Table,Table[Product],Table[Mark]),[Mark])
