cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sivanesan02
Helper I
Helper I

Distinct value with all columns of original table

Hi floks,
I have tired by trying to get DISTINCT value from the original table.
Here is my task is to create table with distinct value,I try DISTINCT(column_name), it retrun only one column with DISTINCT value.
But I want to display all columns.

Anybody please hlep me to clear this.

Thanks in advance ,
Sivanesan C

1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@Sivanesan02 , Try

 

New table = Distinct(Table)

 

New Table =summarize(Table, Table[Col1], Table[Col1] , ......... ) Add all columns

https://docs.microsoft.com/en-us/dax/summarize-function-dax

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

4 REPLIES 4
amitchandak
Super User IV
Super User IV

@Sivanesan02 , In case issue is nor resolved. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Greg_Deckler
Super User IV
Super User IV

@Sivanesan02 - Use the name of the table in your DISTINCT, not the column name.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi @Greg_Deckler ,
Thank you for the response.

amitchandak
Super User IV
Super User IV

@Sivanesan02 , Try

 

New table = Distinct(Table)

 

New Table =summarize(Table, Table[Col1], Table[Col1] , ......... ) Add all columns

https://docs.microsoft.com/en-us/dax/summarize-function-dax

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors