LOOKUPVALUE help

[LRFeltz]

Hello guys,

I need help... I'm including the security function below to restrict access to users.

[FILIAL] IN (LOOKUPVALUE(TBL_ACESSO[FILIAL], TBL_ACESSO[USUARIO], "user x") )

But it generates an error because the function returns more than a value

But I need to release more than one branch for a user, as I do for the function to return more than one row value ?

Does anyone know what I can do ?

thank you!

LR Feltz

[v-haibl-msft]

@LRFeltz

It seems that you want the role members can only see the data for those FILIAL have USUARIO of “user x”.

Why not write the DAX expression as below?

Best Regards,

Herbert