Card to show number of values above 1

[nickcurry]

Hi all! So I have a table that contains unique student numbers. When they take a book, we enter an entry with the student name and their student number.

I want a card to just give me the number of students that took out a book more than 1 time. So if we had 10 students and 3 of them took a book twice or more, I just want the card to say 3.

Any ideas how I would do this? Thank you.

[amitchandak · Accepted solution]

@nickcurry , First create booking measure

cnt = countrows(Table)

cnt Gt 1 = sumx(filter(Values(Table[Student]), [Cnt] >1), [Student])