Measure to show total of count rows

[newtonian1991]

Hi All, 

I'm going crazy here trying to figure out somethign that shold be quite simple. 

I have created the below matrix table. Class abesntee count is a measure. 

Class Absentee Count = COUNTROWS(PupilClassAttendance)

What i need is the total count for each ID. in this case 3 to be a measure itself and shown inline wiht each ID. I assumed this would be simple but havent had any luck. Looking forward to your responses. 

PupilID	PupilCode	Class Absentee Count	PeriodNumber
xx123	xx11	1	4
xx123	xx11	1	11
xx123	xx11	1	12

[parry2k · Accepted solution]

@newtonian1991 when you have other columns in the table visual, it gives the count of the unique value of each row not the count of pupil ID, to test, keep pupil ID and the measure in the visual and you will get the result. If you want all the columns then you need to change the measure to this:

Count = 
CALCULATE ( 
    COUNTROWS ( 'Table' ), 
    ALLSELECTED ( 'Table' ),
    VALUES ( 'Table'[PupilID] )
)

[newtonian1991]

This is exactly what i needed. Thank you so much.