Measure that displays all text in 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 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 table 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-cazheng-msft · Accepted solution]

Hi @Anonymous ,

You may consider this solution.

1 Create Measure as follows

Filter Clients =
CALCULATE (
    COUNT ( clients[Name] ),
    TREATAS ( VALUES ( salemans[Name] ), clients[Name] ),
    FILTER ( clients, clients[Name] IN ALLSELECTED ( salemans[Name] ) )
)

2 Add this measure as the visual level filter of the Table visual created with clients column

Attached the pbix file as reference.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun