Forum Discussion

pratk30's avatar
pratk30
Advocate 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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
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

ToddChitt's avatar
ToddChitt
Super User
6 years ago

v-jiascu-msft 

I have a very similar situation and create the same measure. But when browsing the cube via SSMS, I get the error: 

The function MIN takes an argument that evaluates to numbers or dates and cannot work with values of type String.

So I'm switching to FIRSTNONBLANK.

 

But this creates a MEASURE, and I can't use that in a FILTER on a page.

Any advice is appreciated.