Create table of uniques...

[Matty]

Hi,

My table is as follows:

Shop	Fruit
A	Apple
A	Apple
A	Pear
B	Strawberry
B	Banana
B	Orange
B	Banana

<tbody>
</tbody>

And I need a DAX formula to create the following table:

Shop	Fruit
A	Apple
A	Pear
B	Strawberry
B	Banana
B	Orange

<tbody>
</tbody>

Which represents the unique 'Fruits' and their associate 'Shop'.

Hope someone can help.

Thanks,

Matty

 

[anvg]

Hi
Try

= SUMMARIZE('myTable', 'myTable'[Shop], 'myTable'[Fruit])

Regards,

 

[Matty]

Hi
Try

= SUMMARIZE('myTable', 'myTable'[Shop], 'myTable'[Fruit])

Regards,

Thanks for the steer, anvg!

Cheers,

Matty