Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
Can you provide more details about the relationship and its direction
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?)
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |