Hi,

I am struggling to get my data model to work and would really appreciate if someone could take a look!  Unfortunately I don't seem to be able to upload a pbix file, but I have uploaded one here: MOTH_CarSalesExample.pbix

For purposes of the example I have translated my data into Car sales, using Audi and BMW and tried to keep it as simple as possible.

Dim Tables:

Dealers: Brand (eg Audi), Location (eg Audi London), LocationCode

Cars: Brand eg (Audi), Model (eg A1), ModelCode

Fact Table

Sales: LocationCode, ModelCode, SalesQty

Report (See screenshot in Excel doc)

4 Slicers:

1, Brand (Audi  / BMW)

2, Fuel Type (Petrol / Diesel)

2, Model (A1, A2, A3.... 320D, 520D etc)

3, Location (Audi London, Audi New York...BMW Berlin etc)

And one Matrix table containing: Brand, Model, Sales

Aim

1, I want my Matrix to list all models, for the chosen Brand, regardless of whether they have sales - working - achieved by using option 'Show Items With No Data'

2, When user selects 'Audi' from the Brand slicer, I want the list of cars in the Matrix to only show Audis - working.

3, When user select 'Diesel' from the Fuel Type slicer, I want the list of cars in the Matrix to only show Diesels - working.

4, When the selects Audi London, I want the Matrix to list all Audi vehicles - NOT WORKING.  The Matrix still includes BMW cars.  I want it to list all Audi cars, regardless of whether London have sold any, but not to include BMW.

I wondered if I needed to add a 4th 'Brand' table and link this into my model, but I this doesn't seem to do the trick.

Any help very much appreciated!

Thanks

Mark