Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
@Harry_Tran , Try to create a measure
countx(summarize(Table, Table[teacher id], table[School]),[teacher id])
@Harry_Tran , Try to create a measure
countx(summarize(Table, Table[teacher id], table[School]),[teacher id])
It works, thank you so much
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
120 | |
74 | |
72 | |
58 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |