Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 78 | |
| 46 | |
| 37 | |
| 31 | |
| 26 |