Forum Discussion

pratk30's avatar
pratk30
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Error on using UserName() function in custom table

Hi Folks,   I am getting below error after using measure which stored USERNAME(). CUSTOMDATA, USERNAME and USERPRINCIPALNAME functions are not supported in calculated tables/columns. These functio...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi pratk30,

     

    As we can see from the error message, it isn't supported. What's your purpose? Maybe there are other approaches. For example, we can use a measure like this, then we can filter out these 0s in the Filters.

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

    Best Regards,

    Dale

pratk30's avatar
pratk30
Icon for Advocate I rankAdvocate I
8 years ago

Hi v-jiascu-msft,

 

It worked for me, but as per this solution i need to create this measure for every table where email id is and need current user. Right?

 

 

Regards,

Prateek Mangal

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Prateek,

 

I'm afraid so. 

 

Best Regards,

Dale