Create a measure to filter a slicer with multiples attributes

[Anonymous]

Hello together,

I have following challenge:

we are working on a dashboard to find people with a specific skill asset combination.

The idea is to have 2 big slicer, and select few skills from Slicer 1 and few skills from Slicer 2 to get a list with people with this specific skill asset combination. The slicers, each with a different skill group also differentiate between different skills levels. (Slicer 1 should contain Skillgroup 1 (200 Skills), Slicer 2 should contain Skillgroup 2 (100 Skills).

The Problem is that the slicer logic of powerbi works on an OR logic. The reference links (see below) face a similar issue, although it filters only one attribute.

So I need in my case a multiple selection measure to filter within a slicer multiple attributes in an AND logic.

In the sample below it is from skill group 1 Skill 1 with level 2; Skill 2 with level 3 as well as from skillgroup 2  Skill 6 with skill level 2 selected. In the following Chart only Person X and Y fulfill this criteria and are shown

The Data Model looks like this:

Master Data contains the names of the people

Spec. Skills = Skill Group1

Gen. Skills = Skill Group2

The Solution should look like this:

Related Issue:

- https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Filtering-a-Multi-Select-Slicer-via-...

- Changing “OR” to “AND” Logic for Power BI Slicers | by Orysya Stus | Seismic Innovation Labs | Mediu...

[Anonymous]

Hello @Anonymous 

Thanks for your quick reply.

Unfortunately this approach doesnt fit my case. But this is my fault due lacking description.

Each Skill of the people also has a differ Level of skill which has to be considered.

In my case I selected few skills and would expect to find in the list the amount of people who match the selected combination of skills.

Master DataSkill Group 1Skill Group 2RelationsDashboard

Here I selected few skills and would expect to find in the list the amount of people who match the selected combination of skills. But in the list are more people displayed.

Example: In the Testcase Person B for example doesnt have Skill on Level , but is still displayed

Testcase.pbix 

Best Regards.

[Anonymous]

Hi @Anonymous ,

According to your description, Person ABDE satisfies the first slicer, and Person ABDE satisfies the second slicer. Then Person satisfying both slicers is ABDE. Your result output is correct. Do you mean you want a measure to count the number of people? i.e. the expected result is 4?

Best Regards,

Neeko Tang

[Anonymous]

Hello @Anonymous ,

unfortunately ABDE are not matching both slicer.

When you look on A for Example.

Person A posess the skills:

Skill 1 Level 2

Skill 2 Level 3

Skill 3 Level 2

Skill 4 Level 1

Slicer 1 selected

Skill 1 - Level 1

Skill 2 - Level 3

So here in Slicer 1 is only Skill 2 - Level 3 matching

Same goes for Slicer 2, here is only Skill 4 - Level 1 matching.

BR

[Anonymous]

Hi @Anonymous ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) We can create two slicer tables.

SlicerTable1 = VALUES('Table'[Skill Group1])

SlicerTable2 = VALUES('Table'[Skill Group2])

(3) We can create a measure. 

Flag = 
var _a=VALUES('SlicerTable1'[Skill Group1])
var _b=VALUES('SlicerTable2'[Skill Group2])
RETURN IF(MAX('Table'[Skill Group1]) in _a ||  MAX('Table'[Skill Group2]) in _b,1,0)

(4) Place [Flag=1] on the visual filter and then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.