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
Novice_2022
Frequent Visitor

create measure that displays value from another table to display in table

Good day,

 

I've been searching for some time and haven't been able to find the answer. Any help is appreciated.

 

I need to create a measure that will display value from a selected column that I can display in a table. All I need it to do is mirror the value. I also need to display a total at the bottom. 

 

I have two tables that are related by an ID variable, it's a one-to-many relationship. The two variables I need to display are "Name" and "Number". Name is in Table1 and Number is in Table2. Adding both variables to a table will display the numbers that I need, but the totals are missing. I need that number to display for each individual Name and have a total at the bottom.

 

I apologize but I can't provide screenshots as data I'm working with is confidential. Thank you in advance.

4 REPLIES 4
tamerj1
Super User
Super User

@Novice_2022 

You can add the number column again to the table visual but this time as a SUM measure then manually hide the first one. 

I attempted to do that previously, but then I just get the total number for all of the rows in the table. It gives me 537 for each and every name as a value.

@Novice_2022 

Can you provide more details about the relationship and its direction 

Wilson_
Super User
Super User

Hello,

 

Knowing literally nothing else about your data model, my current thought is you simply need a SUM ( Table2[Number] ) measure to place in your table.


----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.