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.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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