Forum Discussion
cdawidow
Helper III
Helper IIITotal Sales is duplicate
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.
cdawidowHelper III
Helper IIIWell 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
Contracts (2) stores unique names of contracts as much as I understand. Why do you then have many-to-many between Contracts (2) and Contracts? Second question, why is the connection between Contracts and Sales many-to-many with bi-dir filtering? Bi-dir filtering and many-to-many are EXTREMELY DANGEROUS constructs and should be used with UTMOST care (please refer to Power BI documentation). In other words, you should NOT use them if you're just starting learning Power BI.
If you want to create simple, fast and easy to understand models, please read about dimensional modeling that also is the foundation of Power BI modeling. The documentation on Power BI is a good place to start. There are tons of vids on YT as well that explain how you should model data.
If you neglect this part of learning, you'll be sorry rather sooner than later. You run the risk of producing wrong numbers without ever realizing it.
If you want to create simple, fast and easy to understand models, please read about dimensional modeling that also is the foundation of Power BI modeling. The documentation on Power BI is a good place to start. There are tons of vids on YT as well that explain how you should model data.
If you neglect this part of learning, you'll be sorry rather sooner than later. You run the risk of producing wrong numbers without ever realizing it.
- cdawidow
Taking your advice as we speak, Thanks so much