How to group by in power bi

[Harry_Tran]

Hi everyone,

I have a table like this

One teacher can teach at different schools and teach differnet classes.

what I'm trying to do is count teacher group by school.

I used distinctcount and the result is like this

My goal is

Because teacher 1 teaches as 3 school A,B, and C.

If anyone know how to do this, please help.

Thank you so much

[amitchandak · Accepted solution]

@Harry_Tran , Try to create a measure

countx(summarize(Table, Table[teacher id], table[School]),[teacher id])

[Harry_Tran]

It works, thank you so much