Hello,
I have a table that has ID, Application Status, University Name, Date, Current Grade. I am trying to do a distinct count of IDs that have been accepted at the latest date into the latest University. A person can get accepted into more than one university.
I have my current calculation as,
CALCULATE (
DISTINCTCOUNT ( 'Table'[ID] ),
GENERATE (
VALUES ( 'Table'[ID] ),
LASTNONBLANK ( 'Table'[Date], 0 )
),
'Table'[Application_Status] = "Accepted"
)
I am going to be showing the visual on a Matrix table with University names being on the rows, grade being on the column and the measure on the values. However, I am having trouble trying to get the latest university as the count in the calculation. Like the student is getting counted is he/she is accepted in two universities. Any suggestions?
