Forum Discussion

JARP's avatar
JARP
Frequent Visitor
3 years ago
Solved

Row level User principal

Hi everyone, I am working on a dataset with different users for the same project. The emails for each person are in a separate column (Email, Email 2, Email 3 and email 4). I use the following DAX syntax:

[Email] = [userprincipalname] || [Email 2] = [userprincipalname] || [Email 3] = [userprincipalname] || [Email 4] = [userprincipalname]

 

currently, this is working for the first Email, however, for the second, third and fourth emails is not working. 

Any idea how to solve this 

Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , JARP 

    According to your dax code , i think it has no errors in it .

    I test it in my side , i works good like this.

    This is my test data:

    I create a role like this:

    Of cource we can also use the USERPRINCIPALNAME() function .

    And we can test this role in Power BI Desktop:

     

     

     

    If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

2 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , JARP 

    According to your dax code , i think it has no errors in it .

    I test it in my side , i works good like this.

    This is my test data:

    I create a role like this:

    Of cource we can also use the USERPRINCIPALNAME() function .

    And we can test this role in Power BI Desktop:

     

     

     

    If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

     

  • JARP's avatar
    JARP
    Frequent Visitor
    3 years ago

    Thank you Aniya,

     

    Using your Example I notice that one of my filters was causing the error. 

     

    Thank you for your help

     

    JARP