Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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")
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |