Power BI Username()

[Anonymous]

Hi All,

I have created an Calculated column like 

Security = NOT(ISBLANK(LOOKUPVALUE(security_mapping[CATEGORY],security_mapping[CATEGORY],[Category],security_mapping[EMAIL],USERNAME())))

But I am getting error like 

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

Can we use Username() function in calculated column?

Please help me on this.

Thanks

Vannikannan.k

[Greg_Deckler · Accepted solution]

No you cannot, has to be in a measure.