Switch true () to cascade through a list of skills for each distinct associate

[JennS]

I have a table that has a list of associates id's and then a column that provides a list of skills that are assigned to them. The table is formatted as below. How do I get the switch to cascade through the list of skils for each TSR by specific order. For example if they have the code JMSR, they are senior and can switch to true, but if they don't have that skill, I need it to continue to go to the next of JMOV, then on to JMUN..etc.

I am trying to grab the list of distinct associates, for this list go through the list of skills and assign the first or highest skill to the tsr in a new colum

I am using the below for switch true but can't get it by the tsr level.
Switch(
TRUE(),
<table_name>[ts_skill] = 'JMSR', "Senior"
)

ts_tsr	ts_skill
JMMD	JMSR
JMMD	JMOV
JMMD	JMUN
JMXX	JMOV
JMXX	JMUN

[AlexisOlson · Accepted solution]

Grab the skills for the particular tsr and then use SWITCH ( TRUE(), ... )

overall = 
VAR skills =
    CALCULATETABLE (
        VALUES ( Assoc[ts_skill] ),
        ALLEXCEPT ( Assoc, Assoc[ts_tsr] )
    )
RETURN
    SWITCH (
        TRUE (),
        "JMSR" IN skills, "Senior",
        "JMOV" IN skills, "Over",
        "Under"
    )

[JennS]

This worked perfectly!!! You are awesome thank you so much for the help!!! 

[AlexisOlson]

What is the output/result that you are looking to get?

[JennS]

I am looking to get just one overall skill for each TSR. So if they have the code JMSR for Senior and have 4 other skill codes since Senior is my highest level, that TSR would be coded Senior. If the TSR doesn't have JMSR then check for JMOV and assign Over and so on. I just want to assign an Overall skill starting at Senior then Over then Under. Each TSR has multiple skills and I need to assign them the highest skill they have listed. 

[AlexisOlson]

So a calculated column like this?

ts_tsr	ts_skill	overall
JMMD	JMSR	Senior
JMMD	JMOV	Senior
JMMD	JMUN	Senior
JMXX	JMOV	Over
JMXX	JMUN	Over

Or are you trying to write a measure? If you want a measure, does the filter context include ts_skill?

[JennS]

Yes just like the calculated column, that's exactly what I need. Am I able to do this with the switch true?