Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
I have a field StaffMemberType where I want to group values into different categories. Having trouble with the syntax:
If the type is AnesthesiologistAssistant, CRNA or CertifiedAnesthesiologistAssistant then it's CRNA
IF its physician, medicaldoctor or doctorofosteopathy then it's physician
Else it's Other.
This is what I have that is not working:
Job Family = IF('QGenda Compliance'[StaffMemberKey] IN ("AnesthesiologistAssistant", "CRNA", "CertifiedAnesthesiologistAssistant", "CRNA", IF('QGenda Compliance'[StaffPayrollId] IN ("Physician", "MedicalDoctor", "DoctorOfOsteopathy"), 'Physician', "Other")))
Solved! Go to Solution.
@Anonymous , Your logic seems correct I doubt the columns you are using
[StaffMemberKey] and [StaffPayrollId] they do not seem like column hold those values. Also, this is case sensitive comparison
Job Family = Switch( True() ,
'QGenda Compliance'[StaffMemberKey] IN {"AnesthesiologistAssistant", "CRNA", "CertifiedAnesthesiologistAssistant"}, "CRNA"
, 'QGenda Compliance'[StaffPayrollId] IN {"Physician", "MedicalDoctor", "DoctorOfOsteopathy"}, "Physician"
, "Other")
Revised, but still not working. Only getting the result "Other"
Job Family = IF('QGenda Compliance'[StaffMemberKey] IN {"AnesthesiologistAssistant", "CRNA", "CertifiedAnesthesiologistAssistant"}, "CRNA", IF('QGenda Compliance'[StaffPayrollId] IN {"Physician", "MedicalDoctor", "DoctorOfOsteopathy"}, "Physician", "Other"))
@Anonymous , Your logic seems correct I doubt the columns you are using
[StaffMemberKey] and [StaffPayrollId] they do not seem like column hold those values. Also, this is case sensitive comparison
Job Family = Switch( True() ,
'QGenda Compliance'[StaffMemberKey] IN {"AnesthesiologistAssistant", "CRNA", "CertifiedAnesthesiologistAssistant"}, "CRNA"
, 'QGenda Compliance'[StaffPayrollId] IN {"Physician", "MedicalDoctor", "DoctorOfOsteopathy"}, "Physician"
, "Other")
User | Count |
---|---|
84 | |
70 | |
68 | |
58 | |
50 |
User | Count |
---|---|
43 | |
41 | |
34 | |
34 | |
30 |