Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Row Level Security based on EmailID

Hello,   I am working on a dashboard where we have 4 potential users: Business Head, Sales Rep, District Manager and Region Manager. Each Account has 4 of these emails associated and I have an Acc...
Payeras_BI's avatar
Payeras_BI
Icon for Solution Sage rankSolution Sage
5 years ago

Hi Anonymous,

Something like this should work as a Table filter DAX Expression for your main table. 

 

[ID] = CALCULATE ( MIN ( Emails[ID] ), USERPRINCIPALNAME () = Emails[Email] )

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello, thank you for this response. The DAX expression that you gave me, I tried using that for table filter DAX expression however I get this error: "A single value for column 'email' in Table 'XX" cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count or sum to get a single result"

 

Would this measure allow any user that has the email to match to the Account ID and only show that results? 

Not sure why it's not working.

More context: Table 1 (AA) has the Account ID and other account details.

Table 2 (XX) has column 'email' and 'Account ID'. so the DAX I wrote, took it from Table XX, was that right?

  • Payeras_BI's avatar
    Payeras_BI
    Icon for Solution Sage rankSolution Sage
    5 years ago

    Hi Anonymous,

    Please type in the DAX expression used with your tables and column references.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago
      CALCULATE ( MIN ( 'XX'[ID] ), USERPRINCIPALNAME () = XX[email] )

      This is what I typed in the table filter DAX expression when I got the error.