Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 |
Solved! Go to Solution.
@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 , 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])
@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
@gauravnarchal It's the default or are you trying to create a new table? Both are set to Don't summarize.