Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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?

DAX Query
DAX SUMMARIZE
DAX TABLE
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

     

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        amitchandak
        Icon for Super User rankSuper User
        4 years ago

        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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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