Forum Discussion

Lexi_Liu's avatar
Lexi_Liu
Frequent Visitor
3 years ago

Dax Measure based on if Dynamic RLS is applied

Hi, I have set up several security roles and one of them is a dynamic role by using [user email]= userprincipalname() Is there a way we can add condition on a dax measure, if that dynamic role is a...
eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

Hello Lexi_Liu its possible based on what i understood from yoir description but i need more information to be able to help you out please

  • Lexi_Liu's avatar
    Lexi_Liu
    Frequent Visitor
    3 years ago

    Thanks for your response. So basically I have two DAX measure in my reports and their calculation is different. I want to have a new DAX with condition, let's say if someone from the Dynamic User List accessed the report, they will see the first type of calculation, but other user (or by default) will see the second type of calculation.

    Something like: [Condition]=calculate(if(User is from Dynamic Role), [Measure1], [Measure2])

     

    I learnt from another post that looks similar to my question and it looks we cannot make it because "RLS is applied at the dataset level, the measure is created inside the dataset."☹️

    https://community.fabric.microsoft.com/t5/Desktop/Is-there-a-way-to-tell-if-RLS-is-filtering-a-table-using-dax/m-p/708374/highlight/true#M342031