Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
sid-poly
Helper I
Helper I

DAX query for Unique columns and Table creation

Hi,

I am actually looking for a DAX query which can help me give a combination of unique values of two columns. Let me illustrate an example on the same.

 

item no | description | amount

1           |    good        |  20

1           |   good         |  21

1           |   bad           |  30

2           |    good        |   50

 

I need the table that gives me the uniqe combination of item no and description. Like

 

item no | description

1           |    good            

1           |   bad           

2           |    good        

 

I have used the summarizecolumns but still it gives me certain duplicates. Can someone help me on the same?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @sid-poly ,

I have tried @amitchandak  approach,  when I add up the description It doesn't get duplicated.

11.PNG

Table 2 = SUMMARIZE('Table','Table'[item no],'Table'[description])

22.PNG

If I have misunderstood your meaning, please provide more sample data and your desired output.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi @sid-poly ,

I have tried @amitchandak  approach,  when I add up the description It doesn't get duplicated.

11.PNG

Table 2 = SUMMARIZE('Table','Table'[item no],'Table'[description])

22.PNG

If I have misunderstood your meaning, please provide more sample data and your desired output.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

amitchandak
Super User
Super User

@sid-poly , If you put them in table visual it will give, bot should be non/un summarized

 

item no,  description

 

or create a new table = summarize(Table, [item no],[description])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak 

I have done it but eventually when I have only item number I have correct values, but when I add up the description It gets duplicated.

I see that is because item no remains same and description changes, I want to pick the first one from here.
Can you help me on the same?

@sid-poly , You can use a measure for description, Min(Table[description])

 

Can you share exactly what is needed and what you are getting now? above is by default power bi

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.