DAX script not equal rejection
Hello, I need your help, I've attempted to write a DAX script to match first 3 lines "HPI" within a column which meets criteria major_incident_state = "Accepted" but not equal <> "Rejected"(see below). Unfortunately, my DAX version does not work i.e. not to include "Rejected". Any help or suggestion is welcome. Thank you in advance, MI State = IF( 'MajorIncidentTickets_2022-23'[major_incident_state] = "Accepted" && LEFT('MajorIncidentTickets_2022-23'[short_description],3) = "HPI" && 'MajorIncidentTickets_2022-23'[major_incident_state] <> "Rejected", "HPI", "MI" )