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.
Hi guys, I am wondering if there is a way to fix this. My total sales calculation is right, but my sales by contract name is duplicated. Any fix> please see below for my model.
@cdawidow , You can create a bridge table like.
contract Name = distinct(union(all(Hope[contract Name]),all(contracts[contract Name])))
The same way you can create other dimensions/master/bridge tables
Well I just changed my model hopefully you can see below. What I did was I concatenated both the sales and contract tables to create a relationship but still even with this bridge I created my total values were still wrong
Taking your advice as we speak, Thanks so much
@cdawidow - 9 times out of 10 that's an issue with the relationship. It's almost certainly caused by having many-to-many relationships. I would seek to eliminate those using bridge tables most likely.
Thanks for the help!
I just have one unique column in my tables (Contract Name) which is distinct to only its table. How would I create a bridge table that could allow me to calculate total sales by contract name? Thanks in advance
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
28 | |
12 | |
10 | |
10 | |
6 |