Forum Discussion
Solved
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 o...
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.
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.