Modeling problem

[nirrobi]

Hi.

I have problem with model/

attched link for the basic assumption:

https://www.dropbox.com/s/pa9f2vr6jf4n89e/model.xlsx?dl=0

In summary:

I have 3 tables:

1:

Order No - unique

Quote No - not unique (quote can be use by many order)

2:

quote no(not unique)

amount 

makat

3:

order no(not unique)

amount

makat

makat category

I can not make this model to work properly.

I need to be able to connect quote and order and to be able to filter by makat and makat category.

the makat in order and quote are the same

I try to make new table with quote uniqe (append table 2+1) and succeed to connect the amount but not able to filter makat and category properly.

thanks in advanced.

[ankitpatira]

@nirrobi What you need is something like below,

Table 1

Order No - PK

Quote No 

Table 2

Quote No - PK

Table 3

Order No - FK

Quote No - FK

Amount

Makat

Makat Category

You can achieve this via data modelling in power bi desktop or do in your data source. Once you have that done, create relationship in your power bi desktop as,

Table1 PK - Table3 FK

Table2 PK - Table3 FK

Then use should be able to use makat and makat category as slicer to filter table1 or table2 numbers. Ensure you keep cross filter direction to Both.