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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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

Share with Power BI Enthusiasts: 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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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