Table Visualization for Selected Slicer Subgrouping

[Anonymous]

I have a group of data in a table "ItemGroups" with the following format:

 I want to use a slicer to select a single item. Currently, this returns all the groups in which that item number is a part of. What I am looking for is the table visualization to return all item numbers that share the group. In the example below, I want the table visualization to return all item numbers that contain group B (this will include the selection in the slicer), group H, group N, etc.

Can this be done as a visual filter using a measure?

[Anonymous · Accepted solution]

HI @Anonymous,

For original slicer, it is impossible to achieve your requirement.

You need to create new table as source of slicer and coding measure to filter records.

Steps:

1. Create table with 'item number' and 'groups' from original table as select table.(these tables not have relationship)

Selector =
SELECTCOLUMNS ( Table, "Item Number", [Item Number], "Groups", [Groups] )

2. Use Item Number(from selector table) as source column of slicer.

3. Write measure to get selected group list and check original table row content to return tag.

Tag =
VAR selectList =
    CALCULATETABLE ( VALUE ( Selector[Groups] ), ALLSELECTED ( Selector ) )
RETURN
    IF ( SELECTEDVALUE ( Table[Groups] ) IN selectList, "Y", "N" )

4. Drag above measure to visual level filter with advanced filter mode to filter records who not equal to "Y" tag.

Regards,

Xiaoxin Sheng