Create two slicers from two different name fields then sync them into one slicer

[cinsbox]

Hi I am working off a "master data list" which consists of merges of several data lists to create a Dashboard.  I have two name fields in the master list which are used to filter the visuals.  For ease of use, I would like to create two name slicers that consist of the name set of individual names and sync them into one.  However, when I tried to do it, the single slicer is not giving me the right counts, it seems that there's a hierarchy given to one of the name fields.  

The name fields are "ACTION SOLICITOR NAME" and "PROSMGR SOLICITOR NAME."  

Since the two name fields are on the same master list, when I click on the individual name field slicer, it affects all of the visuals too.  Is there a way to make one slicer for the names and then have the names display the visuals according to what the individual slicer intends to?  

[Deevo_]

Hi there, This post is very helpful.

• I have modified this slicer formula to suit my own requirements and include a second column when creating the "Slicer".

Example: 

Slicer =

DISTINCT(

        UNION(SUMMARIZE('Teams', 'Teams'[Division], 'Teams'[Branch]),SUMMARIZE('Project_Codes', 'Project_Codes'[Division], 'Project_Codes'[Branch]))

            )

• How can i modify the "Measure" to allow the user to select the field [Division] and/or [Branch] from the page slicer??

Current measure that only works for [Division]:

Measure =

IF (

    OR (

        SELECTEDVALUE ( 'Slicer'[Division] ) = SELECTEDVALUE ( 'Teams'[Division] ),

        SELECTEDVALUE ( 'Slicer'[Division] ) = SELECTEDVALUE ( 'Project_Codes'[Division] )

    ),

    1,

    0

)

Many thanks!

[v-zhangti · Accepted solution]

Hi, @cinsbox 

You can try the following methods.
Sample data:

Create a table with only Name as a slicer.

Slicer = UNION(VALUES('Table'[ACTION SOLICITOR NAME]),VALUES('Table'[PROSMGR SOLICITOR NAME]))

Measure =
IF (
    OR (
        SELECTEDVALUE ( Slicer[Slicer] ) = SELECTEDVALUE ( 'Table'[ACTION SOLICITOR NAME] ),
        SELECTEDVALUE ( Slicer[Slicer] ) = SELECTEDVALUE ( 'Table'[PROSMGR SOLICITOR NAME] )
    ),
    1,
    0
)

Hope this method helps you.

Best Regards,

Community Support Team _Charlotte

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