Create table of uniques...

[Matty]

Hi,

My table is as follows:

[TABLE="width: 113"]
<tbody>[TR]
[TD]Shop[/TD]
[TD]Fruit[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Pear[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Strawberry[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Banana[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Banana[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 113"]
<tbody>[TR]
[TD]Shop[/TD]
[TD]Fruit[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Pear[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Strawberry[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Banana[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Orange[/TD]
[/TR]
</tbody>[/TABLE]

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