topic Re: DAX query for Unique columns and Table creation in DAX Commands and Tips

DAX query for Unique columns and Table creation

Anonymous — Fri, 07 Jan 2022 11:05:46 GMT

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?

Re: DAX query for Unique columns and Table creation

amitchandak — Fri, 07 Jan 2022 11:24:43 GMT

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

Re: DAX query for Unique columns and Table creation

Anonymous — Fri, 07 Jan 2022 12:15:44 GMT

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?

Re: DAX query for Unique columns and Table creation

amitchandak — Sat, 08 Jan 2022 03:52:01 GMT

Anonymous , 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

Re: DAX query for Unique columns and Table creation

Anonymous — Tue, 11 Jan 2022 02:19:39 GMT

Hi Anonymous ,

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