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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors