cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors