Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
yve214
Helper III
Helper III

help with same user columns in same table

Hi there,

 

Please i need help with how too target a problem like having two user names on the same table.

 

I have an submitted and approved users that have the same data content for instance (please see table below). I also have a user table that gives me the data desciption like the names of these users however, in power bi i can only link the users table to one column (with an active relationship) to my data table. And I linked it to my "submitted user" column which gives me a view as below!

 

Problem:

I want to be able to create a table view where I can only have one user column with their respective metrics instead of user submitted and user approved seperately. 

 

Please see below of sample data view.

 

sample data table:

 

submitted userapproved userentriesapproved
1001100144
1002100155
1003100565
1004101077
1005100585

 

user table (liked to the above sample data table)

userName
1001Ann
1002Peter
1003Christi
1004Paul
1005Dan
1010Will

 

Expected results (would like a single user column with its various aggregates as shown):

 

user nameentriesapproved
1001Ann49
1002Peter50
1003Christi60
1004Paul70
1005Dan810
1010Will07

 

Is this possible to archieve? and if so please help, thank you.

1 ACCEPTED SOLUTION
vapid128
Solution Specialist
Solution Specialist

image.png

image.png

 

approved = CALCULATE( SUM(Table11[approved])) + 0
 
entries = CALCULATE(SUM(Table11[entries]),USERELATIONSHIP(Table11[submitted user],User[user])) + 0

View solution in original post

2 REPLIES 2
vapid128
Solution Specialist
Solution Specialist

image.png

image.png

 

approved = CALCULATE( SUM(Table11[approved])) + 0
 
entries = CALCULATE(SUM(Table11[entries]),USERELATIONSHIP(Table11[submitted user],User[user])) + 0

Wow @vapid128  you are a LIFE SAVER!! Thank you so so much!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.