Forum Discussion
marconimedeiros
7 years agoFrequent Visitor
Creating a list with measure?
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 wa...
- 7 years ago
Hi,
Go to Modelling > New Table and write this measure
=VALUES(Data[Saler])
A new table will get created with all unique saler values.
Ashish_Mathur
7 years agoSuper User
Hi,
Simply drag that column to the Row labels section of a Matix visual. You will get all distinct entries only.
marconimedeiros
7 years agoFrequent Visitor
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_Mathur7 years agoSuper User
Hi,
Go to Modelling > New Table and write this measure
=VALUES(Data[Saler])
A new table will get created with all unique saler values.
- marconimedeiros7 years agoFrequent Visitor
Wow, simply amazing! Thank you!
- Ashish_Mathur7 years agoSuper User
You are welcome.