Forum Discussion

yve214's avatar
yve214
Helper III
4 years ago
Solved

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.

  •  

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

2 Replies

  • vapid128's avatar
    vapid128
    Solution Specialist

     

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