Data model issue

hello Anonymous 

i would do something like below

all relationship are one-to-many with single filter

Sales - Customer using CustomerKey

Sales - Reseller using ResellerKey

the relationship between date and sales is quite tricky since you have three datekey in sales table.

i use OrderDateKey in sales table to connect DateKey in date table (however, this depends on your outcome result).

Hope this will help.

Thank you.

hello Anonymous 

i might be misunderstood your question but i believe it should be fine.

as far as my knowledge, relationship takes same value to connect two tables.

so -1 will be connected to -1 as well.

Also since your reseller is a dim table, the relationship will be one-to-many then it will connect -1 in reseller to all -1 in sales.

Hope this will help.

Thank you.

hello Anonymous 

that is depend on your need.

have those -1 data reviewed, if you dont need those data, then you can remove it (either remove it in PQ or visual filter in PBI). Removing in PQ will make the data disappear in PBI while visual filter only filter out those data from visualization.

Hope this will help.

Thank you.