Forum Discussion

LRFeltz's avatar
LRFeltz
Icon for Advocate III rankAdvocate 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 gener...
General Comment
v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft 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