help with same user columns in same table

[yve214]

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 user	approved user	entries	approved
1001	1001	4	4
1002	1001	5	5
1003	1005	6	5
1004	1010	7	7
1005	1005	8	5

user table (liked to the above sample data table)

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

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

user	name	entries	approved
1001	Ann	4	9
1002	Peter	5	0
1003	Christi	6	0
1004	Paul	7	0
1005	Dan	8	10
1010	Will	0	7

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

[vapid128 · Accepted solution]

approved = CALCULATE( SUM(Table11[approved])) + 0

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

[yve214]

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