Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |