Create a table with distint value

[yyhk123]

Hello,
I am trying to create a table with distint value, but how can I create it?
for example, i have a table as below:

Name | Age | School
Chris,   13,   Harvard
John,  18,  UCLA
Sue, 18, Harvard
Jason, 17, Yale


from the table above, i want to create a column or a table that contains the school
School
1. Harvard
2. UCLA
3. Yale
(no need to number them)

[Shaurya · Accepted solution]

Hi @yyhk123,

That's simple. Just use:

Distinct = DISTINCT('Table'[School])

In case you don't want just the list of names but other data also, like the number of students in that school, then use:

Count = SUMMARIZE('Table','Table'[School],"Number of Students",COUNT('Table'[Name]))

Works for you? Mark this post as a solution if it does!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI