Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
syasmin25
Helper V
Helper V

Distinct Count Accepted in the latest University

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?
2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

Please share some data and show the expected result.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

What if they get accepted into two or more universities on the same (latest) day?

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.