Username() function not working

[somwanshi]

Hi Everyone,

Im trying to filter my visual with current logged in user (with out applying row level security) but it is not working. I have used following dax query for my measure.

New_Total Activity Count = IF(COUNTROWS(DISTINCT(ALLSELECTED('systemusers (2)'[fullname])))<COUNTROWS(DISTINCT(ALL('systemusers (2)'[fullname]))),

COUNT(activitypointers[activityid]),

CALCULATE(COUNT(activitypointers[activityid]),FILTER('systemusers (2)','systemusers (2)'[internalemailaddress]=USERNAME() )))

When I replace Username() function with some email Id for example "xxx@example.com" it works.

Kindly advice

Thank you.

[v-lid-msft · Accepted solution]

Hi @somwanshi ,

As the Online Document, The username() function will return the format as domain\user locally, if you always want to get UPN email address format, you can use the USERPRINCIPALNAME() function.

Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more