Add Filter in mahage roles

[Anonymous]

hi, 

I'm new (:  I would appreciate your help

How can I ask such a question in mahage roles :

case when (userprincipalname() = 'dd@gmail.com' then [KEY] = 81 || [KEY] =82 || [KEY] = 86)

        when (userprincipalname() = 'ss@gmail.com' then [KEY] = 87 || [KEY] =88 || [KEY] = 89)

end

thanks (:

[Greg_Deckler]

Not sure I understand this. Perhaps something didn't come through in translation? mahage roles? RLS?

You would want to use a SWITCH statement. Perhaps this will assist. https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Hierarchical-Row-Level-Security/m-p/...

[Mariusz · Accepted solution]

Hi @Anonymous 

Try this article 

https://radacad.com/dynamic-row-level-security-in-power-bi-with-organizational-hierarchy-and-multiple-positions-in-many-to-many-relationship-part-1

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn