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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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