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
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |