Forum Discussion

Kristofferaabo's avatar
Kristofferaabo
Helper IV
8 years ago
Solved

mastertable based on groupby or summarize

Hi,   I want to create a new table (Table A) based on colulms from another table (Table B).   In my table A I want only unique/distict values from Column A in Table B to be returned, like a pivot...
Need Help
Show and Tell
Tips and Tricks
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi Kristofferaabo

     

    Both should provide unique values.  I wonder if you have leading, or trailing spaces that need to be cleaned using TRIM 

     

    eg, if I have Table B with the following data

     

    Country

    ----------

    A

    A

    A

    B

    B

     

    The output of the DAX I gave you should be

     

    Country

    ------------

    A

    B

     

    I have attached a PBIX file

     

     

Kristofferaabo's avatar
Kristofferaabo
Helper IV
8 years ago

Hi Phil_SeamarkI think I have tried this, but it wont return unique values.. For instance I column A was a country column, I only want United States to be returned once.

 

 

Do I do something wrong?

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi Kristofferaabo

 

Both should provide unique values.  I wonder if you have leading, or trailing spaces that need to be cleaned using TRIM 

 

eg, if I have Table B with the following data

 

Country

----------

A

A

A

B

B

 

The output of the DAX I gave you should be

 

Country

------------

A

B

 

I have attached a PBIX file

 

 

  • cosminc's avatar
    cosminc
    Post Partisan
    7 years ago

    Hi all,

    i have seen your discussion and i have a similar situation but with one step further

    on main table i have also a column like Sales; and i want to obtain a new table like yours, with unique values, but also with sum of Sales for each

    is it posible?

    Thanks,

    Cosmin