Creating a list with measure?

[marconimedeiros]

Hello folks,

I have a table column with some strings:

Seller 1

Seller 2

Seller 2

Seller 1

Seller 3

Is possible to create a measure to return the distincts values from the column? I want to plot in a matrix visual.

The results I need is:

Seller 1

Seller 2

Seller 3

Anyone can help me, please?

Thanks!

[Ashish_Mathur]

Hi,

Simply drag that column to the Row labels section of a Matix visual.  You will get all distinct entries only.

[marconimedeiros]

Haha!

Yes, I know this possibility.

But, for some reasons, I need create a measure that returns this same info you suggest to me!

[Ashish_Mathur · Accepted solution]

Hi,

Go to Modelling > New Table and write this measure

=VALUES(Data[Saler])

A new table will get created with all unique saler values.

[marconimedeiros]

Wow, simply amazing! Thank you!

[Ashish_Mathur]

You are welcome.