How to create a slicer for a combination of selection

[PBI_newuser]

Hi, I want to create a slicer as below so that I can view the total labor hours by selecting the slicer.

For example, when I select "Multiple Repairs - Yes", the total labor hours = 11.5 hours.

When I select "Failed to Install", the total labor hours = 9.9 hours.

When I select "ELF - Yes", the total labor hours = 9.6 hours.

When I select "Task Code-FCN", the total labor hours = 10.6 hours.

How to create a column/measure for that?

Slicer: 

• Multiple Repairs - Yes
• Failed to Install
• ELF - Yes
• Task Code - FCN

Job#	Multiple Repairs	Case Reason	ELF	Task Code	Labor Hours
Job-123	Yes	Service	Yes	FCN	2
Job-234	No	Failed to Install	Yes	Repair	3.5
Job-345	No	Issue	No	Install	1
Job-456	No	Failed to Install	No	FCN	6.4
Job-567	Yes	Service	No	Repair	3.2
Job-678	Yes	PM	Yes	Repair	4.1
Job-789	Yes	Implentation	No	FCN	2.2

[Jos_Woolley · Accepted solution]

Hi,

Try the following measure, which assumes that the data is in a table named Data Table and that your four slicer choices are in a column named Slicer in a table named Slicer Table. 

Total Labor Hours =
VAR S =
    SELECTEDVALUE ( 'Slicer Table'[Slicer] )
RETURN
    CALCULATE (
        SUM ( 'Data Table'[Labor Hours] ),
        CONTAINSSTRING (
            'Data Table'[Multiple Repairs],
            IF ( S = "Multiple Repairs - Yes", "Yes", "*" )
        ),
        CONTAINSSTRING ( 'Data Table'[ELF], IF ( S = "ELF - Yes", "Yes", "*" ) ),
        CONTAINSSTRING (
            'Data Table'[Case Reason],
            IF ( S = "Failed to Install", S, "*" )
        ),
        CONTAINSSTRING (
            'Data Table'[Task Code],
            IF ( S = "Task Code - FCN", "FCN", "*" )
        )
    )

Regards

[PBI_newuser]

Thank you so much @Jos_Woolley ! It works.

[Jos_Woolley]

You're welcome!