Power BI Filter By Multiple Criteria using “AND”

Question

I am having a database which shows employees and their skills and want to use slicer for selecting mutiple values and show employees that all skills are selected 

I have selected multiple values and "Or" is applied 

How can I modified the reports with "AND" as criteria?

Answer 1

Use the following measure to do that

Employees with all skills =
CALCULATE (
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            VALUES ( 'dw Employee'[ADUserId] ),
            "Skills", CALCULATE (
                COUNTROWS ( VALUES ( 'dw Skill'[SkillName] ) ),
                CALCULATETABLE ( 'dw EmployeeSkill' )
            )
        ),
        [Skills] = COUNTROWS ( ALLSELECTED( 'dw Skill'[SkillName] ) )
    )
),
ALLSELECTED ( 'dw Skill'[SkillName] )
)

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification