One slicer to control two other slicers?

[MojoGene]

My dataset consists of time and billing data for a professional services firm. Each matter handled by the organization involves multiple timekeepers (Timeslips[Timekeepers]) who work on Matters, buy only one "Responsible Timekeeper" (Matters[ResponsibleTimekeeper]). (Any Timekeeper can be designated as a "ResponsibleTimekeeper", but there is only one ResponsibleTimerkeeper per Matter.)

I am trying to filter the data in such a way that the result shows only values where the ResponsibleTimekeer is also the Timekeeper. I can do this, of course, by putting two slicers on the report, one for ResponsibleTimerkeepers and the other for Timekeepers and choosing the same ID for each slicer. The other thing that occurs to me is that I could create separate measures for each ResponsibleTimekeeper/Timekeeper combination and use a disconnected table to "Switch" from among the combinations. 

Can I create a disconnected slicer that simultaneously select both the REsponsibleTimekeeper and the Timekeeper with one stroke? 

Thanks.

[PavelR · Accepted solution]

Hi @MojoGene,

what about creating simple calculated column where you find out if the Responsible timekeeper is the same as Timekeeper (IF formula). You will have slicer "Same timekeeper" with values "Yes" and "No". Then when you select "Yes", you will have only those Timekeepers (data) which are concurrently in both roles.

Regards.

Pavel

[MojoGene]

Thanks for the input from both. PavelR's suggestion worked. I had to create a new column in the Timeslips table, which I called RTimekeeper:

RTimekeeper = RELATED(Matter[ResponsibleTimekeeper])

 Then a new column in the Timeslips table:

SameTimekeeper = IF([RTimekeeper]=[Timekeeper],"Yes","No")

Thanks for the help!!

[PavelR]

You are welcome @MojoGene.

Regards

Pavel

[Baskar]

i didn't get u clearly.

for my understand do u want to stop the interaction while slicer click ?

let me give soma sample screen shot or data i will helpus to clear ur prob . i hope.