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

[Novice_2022]

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.

[tamerj1]

@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. 

[Novice_2022]

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.

[tamerj1]

@Novice_2022 

Can you provide more details about the relationship and its direction 

[Wilson_]

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?)