Show rows with no values

[Death4Free]

Hi,

I have two tables Assortiment and Data with association on item_key. How to get Result table as below with filter on assort_category? What I need to change - data model or measure calculation sum(sales)? There is millions rows in both tables, so i need to think for performance too.

[DavidŠtorek]

Hi,

there is not perfect key, which means that some values cannot be paired with values from second table. And that is the reaso why you see what you see.

I don't know the logics behind your data model so it is difficult to tell what to change. Could you try to explain in more details?