Filter with related

[Tiago_Pereira]

Hello everyone, I'm having trouble finding the solution I need your help please.

I have two tables one called "Proposta" and another called "Produtos detalhe". In the "Proposta" table I have several related products from the "Produtos detalhe" table.

I need to build a dashboard with filters that searches and filters a certain product in the "Proposal" table and presents it. I'll show you what I've done

it doesn't work because it will show all the same products repeated as shown in the image. I needed him to join

In the filter, that is the table "Atualização BD", I have  Column "Products" with REF for the table "Produtos detalhe" and Valid If formula for column "Produtos"  

UNIQUE(Proposta[Related Produtos detalhes])

In the dashboard i have a slice 

with row filter condition : 

ISNOTBLANK(
FILTER("Atualização BD",
AND(
IN([_THISROW].[AM],SPLIT(Atualização BD[AM],",")),
IN([_THISROW].[Related Produtos detalhes],SPLIT(Atualização BD[Produtos],","))
)
))

if you need more information please say

Can you Help please 

[Tiago_Pereira]

"Proposal"="Proposta" and "Products" ="Produtos"

sorry for the translation

[AleksiAlkio]

May I ask why don't you use the advanced search tool for this purpose.. and you would not need to create your own?

[Tiago_Pereira]

Hi

because it doesn't look in the filters the related colum "Related Produtos detalhes" 

[AleksiAlkio]

The reason why that formula doesn't work. You are trying to compare list against list with both of your IN() expressions.

[Tiago_Pereira]

Ok and which expression should i use to give me the "produtos" without a list? 

[AleksiAlkio]

You could use for example COUNT(INTERSECT(YourList#1,YourList#2))<>0.

[AleksiAlkio]

https://support.google.com/appsheet/answer/10107963?hl=en&sjid=18289475421004495365-EU

[Tiago_Pereira]

In this moment when i select the filter view "Filtros" -> " Produtos" only gives me one result even if I have many in the "Lista das propostas filtro"