Measure to create 2 slicers that displays name with an Inactive relationship

[Anonymous]

Hello guys i have a table salemans: 

Name	Salesman
A	Name1
B	Name1
C	Name1
D	Name1
E	Name1
F	Name1
G	Name2
H	Name2
I	Name2
J	Name2
K	Name3
L	Name3

so the main slicer without a measure should show :

Name1

Name2

Name3

which is easy 

but i have a second table of call clients:

Name

A

B

C

D

E

F

G

H

I

J

K

L

O

P

Q

R

S

T

U

V

so if i select name 3, i want the slicer to display "K" and "L"

i created an inactive relationship between the 2 because i cant create a direct relationship

i know how to do the filter and userrelationship but i dont know how to select all names not only max.

it should look something like this:

measure = CALCULATE("Function to display the names" (Clienttable[name]),

FILTER (

ALLSELECTED ( Clienttable ),

        Clienttable[Name]

            IN FILTERS (Salesman[Name] )

),USERELATIONSHIP(Clienttable[Name],Salesman[Name]))

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can try the following methods.

Measure = CALCULATE(MAX('Table 2'[Name]),USERELATIONSHIP('Table 2'[Name],'Table'[Name]))

Measure 2 = IF([Measure] in VALUES('Table'[Name]),1,0)

Place Measure2 in name slicer and set equal to 1.
Result:

Is this the result you expect?

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.

[PabloDeheza]

Hi there!

If you want a slicer from one table to be filtered by a slicer from another table you can use this measure and apply it in the filter pane, in the filter pane you should select "Cross Dim Filter is 1"

Cross Dim Filter = INT ( NOT ISEMPTY ( ‘YourFactTable’ ) )

 Let me know if that helps!