Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 functions may only be used in Measures or in the AllowedRowsExpression.
Measure
CurrentUser = USERNAME()
Custom table
LingeringDS = FILTER(AssignmentTimephasedDataSet, AssignmentTimephasedDataSet[ResourcesOwner.ResourceEmailAddress] = [CurrentUser])
I need to filter one table data with current logged in user's email id in both Power BI desktop and Service.
RLS is one the option but not suited to my requirement.
Can anyone plase help me on this.
Solved! Go to Solution.
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
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 wrote:Hi @pratk30,
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
Fortunately, I got this to work for me, but I find it rather unintiutive... My beginner DAX mind says the following should have been sufficient:
IsCurrentUser = 'AssignmentTimephasedDataSet'[ResourcesOwner.ResourceEmailAddress] = USERNAME()
Unfortunately, DAX does not seem very intuitive as far as I can tell.
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.
Proud to be a Super User! | |
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
Hi Prateek,
I'm afraid so.
Best Regards,
Dale
User | Count |
---|---|
63 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
41 | |
40 |