DAX help - marking records

[dataguy4u]

Hello,

I have data where employees have more than one Teaching Credential.  Need to know how to create a new measure to identify those records.  Maybe a field called "More than one credital" and mark as Y one time for said employee ? This would be done in Power BI Desktop.  I'm new to DAX and been thinking of a way to mark these records.

Example of data below:

Employee ID	Name	Title	Teaching Credential
12345	Teacher 1	Teacher Special ED	Elemetry Ed K-8
12345	Teacher 1	Teacher Special ED	Special ED K-12
98745	Teacher 2	Teacher , Sub	Emergency Substitute
98745	Teacher 2	Teacher , Sub	Substitute Teacher
98745	Teacher 2	Teacher , Sub	Health/Fitness Prim     K-12
32165	Teacher 3	Instructional Facilitator	Early Childhood Education   P-3
32165	Teacher 3	Instructional Facilitator	Elementary Ed K-8

Much thanks!

Pete

[dilumd · Accepted solution]

Hi,

Pls tell me, Teaching Credential column is the only reason for duplicates line in your data set?

If so, this formula would work for you. 

More than one credital = IF(CALCULATE(COUNTROWS(Help),ALLEXCEPT(Help,Help[Employee ID                 ]))>1,"Yes","No")