DAX help - marking records

Question

Hello,&nbsp;I have data where employees have more than one Teaching Credential.&nbsp; Need to know how to create a new measure to identify those records.&nbsp; Maybe a field called "More than one credital" and mark as Y one time for said employee&nbsp;?&nbsp;This would be done in Power BI Desktop.&nbsp; I'm new to DAX and been thinking of a way to mark these records.&nbsp;Example of data below:&nbsp;Employee ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Title&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Teaching Credential12345Teacher 1Teacher Special EDElemetry Ed K-812345Teacher 1Teacher Special EDSpecial ED K-1298745Teacher 2Teacher , SubEmergency Substitute98745Teacher 2Teacher , SubSubstitute Teacher98745Teacher 2Teacher , SubHealth/Fitness Prim &nbsp; &nbsp; K-1232165Teacher 3Instructional FacilitatorEarly Childhood Education &nbsp; P-332165Teacher 3Instructional FacilitatorElementary Ed K-8&nbsp;Much thanks!&nbsp;Pete

dilumd · Accepted Answer

Hi,&nbsp;Pls tell me,&nbsp;Teaching Credential column is the only reason for duplicates line in your data set?&nbsp;If so, this formula would work for you.&nbsp;More than one credital = IF(CALCULATE(COUNTROWS(Help),ALLEXCEPT(Help,Help[Employee ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ]))&gt;1,"Yes","No")&nbsp;&nbsp;&nbsp;

Forum Discussion

DAX help - marking records

1 Reply

Related content

Mark records with multiple keys

Question mark as operator

Sorting Records

Eliminate duplicate records while keeping the most recent record.

Counting Non-Blank Records

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