Create dynamic table based on text filter values

Hi phuocnguyen ,

You can try below steps:-

1. Create a seperate table with below code:-

Table = DISTINCT(Sheet1[OrigSalesId])

2. Use newly created table column in the search text visual.

3. Now Create a measure with below code and use it as filter on your table visual:-

_filter =
IF (
    MAX ( Sheet1[OrigSalesId] ) = SELECTEDVALUE ( 'Table'[OrigSalesId] ),
    1,
    0
)

Below is your file for your reference:-

 https://file.io/hLllhowC6hjc

Thanks,

Samarth