Forum Discussion
USERPRINCIPALNAME in Column
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.
kurtsmetana Columns are not dynamic, they are calculated at the time of data load. Thus, you cannot use those functions in columns, only measures.
3 Replies
kurtsmetana Columns are not dynamic, they are calculated at the time of data load. Thus, you cannot use those functions in columns, only measures.
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))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
)
