Forum Discussion

LRFeltz's avatar
LRFeltz
Advocate III
9 years ago

LOOKUPVALUE help

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

General Comment

1 Reply

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    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