DAX query for Unique columns and Table creation

[sid-poly]

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?

[v-rongtiep-msft · Accepted solution]

Hi @sid-poly ,

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

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

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]

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

[sid-poly]

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?

[amitchandak]

@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