count of specifc value without making relationship

[Anonymous]

hi everyone!!
can we count number of specific value without making relationship for each row to show in table.

Say i get two list of names from two different tables using values function and for every name present in list one we get the number of accurance of the same name in list two.

say i have list from table 1 with name ( john, Doe, michle)

and another list with name (john, doe ,michle, john, john, doe)

so if i use names of list one to use in slicer to filter and when i click john than  i should get 3 for john similarly 2 for doe selected 

and these all values should be in a table.
Due to my schema restriction i cannot make relationship between these two tables.  

Kindly help me

[amitchandak · Accepted solution]

@Anonymous , Not very clear, you can create a separate name table and join it both columns, one will active another one will be inactive and you can use userealtionship to activate join

refer: https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

https://youtu.be/e6Y-l_JtCq4

Or you can keep that as in independent Table and filter in measure

like

calculate(countrows(Table), filter(Table, Table[Name] in values(Name[Name])))