Need help on formula

[DjLeiiii]

this how many employee table looks like, at the [department] it was enum list which link to the other table of DEPARTMENT.

which mean my employee can end up with multiple position

So this is another table which is WORK ORDER, so in this table theres a column [Salesman] with enum and base was ref to employee. I want those employee department that consist of sales advisor. This sales advisor key was "c16b6a4f-85d6". So this [internalsalesman] will only show those employee which department consists of SALES ADVISOR(key- "c16b6a4f-85d6")

[JuneCorpuz · Accepted solution]

Hey there-

1. Create a slice under your Employees with an expression: IN([Department], “KeyOfSalesAdvisor”)

2. Under Valid_If or Suggested_Values, put this expression: SliceNameFromNumberOne[TableID] or if you want the choices to be sorted: ORDERBY(SliceNameFromNumberOne[TableID], [SortingColumn])

[DjLeiiii]

Thank You Brother 🙂 Cheers