USERPRINCIPALNAME in Column

[kurtsmetana]

Hello we are recieving below error.  Based on the userprincipalname, we want to change the value of a column.  Any ideas?

CUSTOMDATA, USERNAME, USERCULTURE and USERPRINCIPALNAME functions are not supported in calculated tables/columns. These functions may only be used in Measures or in the AllowedRowsExpression.

[Shravan133]

try this in a measure Assuming you have a table called UserData with columns like Username and Value. You want to filter or adjust the Value column based on the current user’s USERPRINCIPALNAME

Filtered Value =
VAR CurrentUser = USERPRINCIPALNAME()
RETURN
CALCULATE(
SUM(UserData[Value]),
UserData[Username] = CurrentUser
)

[ahadkarimi]

Hey @kurtsmetana, it seems you want to filter one table's data based on the currently logged-in user's email ID in both Power BI Desktop and Service, but RLS is not suited to your requirement.
 you can use this and let me know if there is any problem.

Measure = CALCULATE (IF ( MIN ( 'AssignmentTimephasedDataSet'[ResourcesOwner.ResourceEmailAddress] )= USERNAME (),1,0))

[Greg_Deckler · Accepted solution]

@kurtsmetana Columns are not dynamic, they are calculated at the time of data load. Thus, you cannot use those functions in columns, only measures.