topic Re: Create dynamic table based on text filter values in DAX Commands and Tips

Create dynamic table based on text filter values

phuocnguyen — Mon, 10 Jan 2022 04:03:13 GMT

Hi guys, i need felp for this:

As you can see I have a TEXT FILTER and TABLE displayed below:

What I need here is to hide all the values in the table as the first sight, user can only see the values by typing what they need in the search box).

Re: Create dynamic table based on text filter values

VahidDM — Mon, 10 Jan 2022 04:07:47 GMT

Hi phuocnguyen

did you add the OrigsalesId column to the field of Text filter visual.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Create dynamic table based on text filter values

phuocnguyen — Mon, 10 Jan 2022 06:23:26 GMT

Dear VahidDM ,

Yes it is

Re: Create dynamic table based on text filter values

VahidDM — Mon, 10 Jan 2022 06:48:47 GMT

Can you share your PBIX file?

Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

Re: Create dynamic table based on text filter values

phuocnguyen — Mon, 10 Jan 2022 07:02:47 GMT

Sure VahidDM

Please use this link:

https://drive.google.com/file/d/1ARRsaCmksZjzdLOtC9se07uJdxYQ64Nf/view?usp=sharing

Re: Create dynamic table based on text filter values

Samarth_18 — Mon, 10 Jan 2022 07:19:51 GMT

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

Re: Create dynamic table based on text filter values

phuocnguyen — Mon, 10 Jan 2022 07:31:45 GMT

Hi Samarth_18 ,

Thank you for your instruction, but the file has been deleted, could you check it again?

Re: Create dynamic table based on text filter values

Samarth_18 — Mon, 10 Jan 2022 07:34:38 GMT

phuocnguyen ,Please check your Private message. I have sent you updated url.

Re: Create dynamic table based on text filter values

phuocnguyen — Tue, 11 Jan 2022 06:16:38 GMT

Thank you, this work well for me.