topic Re: Need help for creating measure which supports AND operation in DAX Commands and Tips

Need help for creating measure which supports AND operation

powerbidev123 — Mon, 03 Jun 2024 14:47:03 GMT

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

Re: Need help for creating measure which supports AND operation

Greg_Deckler — Mon, 03 Jun 2024 16:33:37 GMT

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

Re: Need help for creating measure which supports AND operation

powerbidev123 — Mon, 03 Jun 2024 17:08:05 GMT

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

Re: Need help for creating measure which supports AND operation

powerbidev123 — Mon, 03 Jun 2024 17:13:30 GMT

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

Re: Need help for creating measure which supports AND operation

ThxAlot — Mon, 03 Jun 2024 19:15:08 GMT

Re: Need help for creating measure which supports AND operation

Greg_Deckler — Mon, 03 Jun 2024 20:07:10 GMT

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

Re: Need help for creating measure which supports AND operation

powerbidev123 — Tue, 04 Jun 2024 06:04:04 GMT

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],",")