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.
I have a simple data model. Two tables (1 to Many).
on the lookup table I use a numerical ($) column as the 3rd row, when drill down opens it ... it's shows the total for that category and not the value. So every row in that category shows the total.
is there an obvious step I am missing?
Hi @PBInonpro ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
Have you checked if your 2 tables have relationship?
or check if the visualization has summed up your values correctly
@PBInonpro Can't quite picture what is going on. A screen shot might help. Sample data as text always helps as well.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
70 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
97 | |
88 | |
59 | |
43 | |
40 |