Identify common mobile number

[Sunil645454]

I have mobile numbers and one number can have multiple reference id's so the requirement is when I select one reference id then table should show all reference id with respect to mobile number means mobile number associated with selected reference id. so want to see all reference id with common mobile number after selection of one reference id through filter , example Data:
Load*
Inline [
Reference_ID,Mobile_Number
Ref12345,9999999999
Ref56789,9999999999
Ref98765,8888888888
];

so when select Ref12345 in filter then my table should show result Ref56789,9999999999

[rubenmarin]

Hi, if you don't want to show your current selection in the table, the expression could be:

Only({<Mobile_Number=P(Mobile_Number), Reference_ID={"*"}-P(Reference_ID)>} Mobile_Number)

To also show the selected Reference_ID it could be:

Only({<Mobile_Number=P(Mobile_Number), Reference_ID=>} Mobile_Number)

[ManimekalaiS]

Create 1 variable. In that variable predict  GetFieldSelection(RefID) mobile no. In table chart using set analysis pass this variable to mobile no field and get the refid's