Business between subsidiaries
For the purpose of internal transactions, QuantoBikes subsidiaries are listed in the global supplier list and therefore appear in the Supplier table. A QMB Subsidiary column denotes these special suppliers with the value 1, whereas all normal suppliers have a value of 0 in this column:
Figure 2.5.3: QuantoBikes subsidiaries
Similarly, each subsidiary that sells to another subsidiary needs to add the subsidiary to its customer list. In the Customer table, an Internal column is used to distinguish between internal and external customers:
Figure 2.5.4: Internal customers have an Internal value of 1
We can now create DAX measures that do or do not include internal customers using the Internal column. In other words, we can either calculate a subsidiary view (including internal customers) or a consolidated view (excluding internal customers).
Subsidiary view versus consolidated view
When analyzing sales, it is important to...
