Need help for creating measure which supports AND operation

[powerbidev123]

I have a table 

Name	Skill
A	Automotive
A	Amazon RDS
B	Amazon RDS
B	Automotive
C	Amazon RDS
C	Automotive
C	Azure

I needed help with creating a measure based on below criteria:

A slicer(Skill) selection needs to be created such that upon selecting 1 or more skill the common set of Name values will be printed

a table visual.     Also the same condition I need to put it up on card visual to show the number of the unique count of Name.

For example : If I select 'Automotive'  and 'Amazon RDS'   from skill slicer I should get A,B,C as values since all of them have commonality of skill in them but  if I select  'Automotive'  and 'Amazon RDS' and 'Azure' then I should get no values since all 3 skills are not present for any employee at the same time

[ThxAlot]

[Greg_Deckler]

@powerbidev123 I built one of those once. Not the only way to do it but one way: (1) Patient Cohort (AND Slicer) - Microsoft Fabric Community

[powerbidev123]

Hey @Greg_Deckler  thanks for the resource. It helped me solve the ANDing part. However I had doubt if I want to just return the names without concatenate at the end but just return only names how can I do that. Because I would be using that measure in place of my old name column

[powerbidev123]

@Greg_Deckler  basically i want to use it as a column which I can use it in a table visual along with other fields

[Greg_Deckler]

@powerbidev123 I would combine that approach with The Complex Selector. Essentially, you just need to grab the MAX value of the Name column and check to see if it is IN the table prior to CONCATENATEX. The Complex Selector - Microsoft Fabric Community

[powerbidev123 · Accepted solution]

Hi @Greg_Deckler , can you please help me with the code . I tried at my end but not getting the correct outcome. This is the code :

SkillSelection =

VAR tmpTable1 = GENERATE(VALUES(Query1[Name]),

                         EXCEPT(

                                VALUES(Query1[Skill]),

                                CALCULATETABLE(VALUES(Query1[Skill]))))

VAR tmpTable2 = SUMMARIZE(tmpTable1,Query1[Name])

VAR tmpTable3 = EXCEPT(VALUES(Query1[Name]),tmpTable2)

RETURN CONCATENATEX(tmpTable3,Query1[Name],",")