Hello, How can i resolve this expression? ...

[Tiago_Maciel]

Hello,

How can i resolve this expression?

Thanks

[Aleksi_Alkio]

AND([situacao]=“Ativo”,IN(USERSETTINGS(…),elementos[agrupamento])) Translate

[Tiago_Maciel]

@Aleksi_Alkio thanks but doesn’t work.

[Aleksi_Alkio]

Glad you found the solution!

[Aleksi_Alkio]

What is the result or error?

[Tiago_Maciel]

@Aleksi_Alkio

[Aleksi_Alkio]

When you are using the value from the USERSETTINGS table, you should add that field name as well. The alert is asking that field name.

[Tiago_Maciel]

@Aleksi_Alkio ok, but i want to list the rows from one table that contains the same value of the USERSETTINGS value.

how can i do that?

[Aleksi_Alkio]

Okay… AND([situacao]=“Ativo”,USERSETTINGS(…)=[agrupamento])

[Tiago_Maciel]

@Aleksi_Alkio thanks but i don´t get that.

[Aleksi_Alkio]

May I ask what is the problem with my above formula? What is the goal for this formula? With that formula, it will show you all rows in a slice when both of those evaluations are true.

[Tiago_Maciel]

@Aleksi_Alkio Thanks, it works. On USERSETTINGS(…) missing USERSETTINGs(Agrupamento).

The correct is AND([situação]=“Ativo”, USERSETTINGS(Agrupamento)=[agrupamento])

Thanks again