Forum Discussion

gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
6 years ago
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...
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    gauravnarchal - Use 

    Measure = CONCATENATEX(DISTINCT(SELECTCOLUMNS('Table',"Product",[Product])),[Product],",")
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    gauravnarchal It's the default or are you trying to create a new table? Both are set to Don't summarize.

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

gauravnarchal - Use 

Measure = CONCATENATEX(DISTINCT(SELECTCOLUMNS('Table',"Product",[Product])),[Product],",")
gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost Prodigy
6 years ago

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],",")