Forum Discussion
ASIGN ROLES
Hola!! Buenas!
He construido un informe en powerbi con 3 niveles de filtro diferente, y me gustaría fijar el valor de esos filtros según quién sea el usuario final de este informe.
Para solventarlo, pensé en los niveles de seguridad de fila, asignando roles desde powerbi desktop.
Me surge un problema,
He incluido varias estadísticas que se calculan con el total de los datos, al asignar un rol los totales no los calcula con el total de datos sin filtrar aún habiendo añadido en la medida DAX un ALL(). ¿Podéis ayudarme en esto?
Gracias
Hi, when you use row level security, it essentially makes all other rows not exist to that person. A potential work around that I have used is duplicating the tables for those statistics that need to be available to everyone and then using filters to prevent users from drilling down to where they shouldn't be.
2 Replies
tchristy99Helper II
Hi, when you use row level security, it essentially makes all other rows not exist to that person. A potential work around that I have used is duplicating the tables for those statistics that need to be available to everyone and then using filters to prevent users from drilling down to where they shouldn't be.
v-kelly-msftCommunity Support
Hi rocesp ，
If you are using RLS,you'd better NOT use ALL(),but ALLSELECTED() instead.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!