I have the following tables in a published dataset:
Customers:
Columns: customerID, VAT number, customer name, address...
One VAT number can have multiple customerID's (so VAT number is not unique).
Products:
Columns: product ID, product name, supplier...
Turnover (= fact table):
Columns: orderID, customerID, productID...
The following relationships exist:
- from Customers to Turnover, 1 to many, single (on customerID)
- from Product to Turnover, 1 to many, single (on productID)
I want to add the following table to the model (from an excel on Sharepoint):
Labels:
Columns: VAT number, supplier, label
This is a limited set of customers (although not customerID's but VAT numbers (!)).
For each VAT there is a row per supplier and the label to follow (for that customer with that supplier) (so VAT number is not unique neither here).
Some customers have 1 supplier (=1 row), others have more (there are only 5 suppliers) (=max 5 rows).
There are 3 possible labels.
How to link the Labels table to the model (what table?) to be able to see the turnover per customer (VAT & customerID's) per supplier, and their label for that supplier (in the same table visual)?
I assumed both linking with the customers table and the product table, but i get an error like this:
"Table Product filters table Customer, which is from the same PBI data source or AS data source, through a path that exists outside of the data source: Product -> Labels -> Customer".
Any ideas?
Is it related to the fact that it is a mixed model?
Thanks!
