Relationships / Cardinality / Cross filter direction in Power BI

[Saniat]

Hi,

I have two tables and their relationship is as below:


    


Table 1 is my main table, and I am using table 2 as a lookup table to get some additional info about the PN.

My thought was when I apply a slicer, I should use that from table 1, since table 1 is more complete (e.g. there is one record which does not exist in table 2 i.e. PN 117).

But I guess my concept is wrong, as slicing for one country from table 1 still gives me total count for table 2:

Can someone explain what should I do here to get 4 in both CountDistinct_PN ?

Many thanks.

[amitchandak]

@Saniat , Table 1 filter will not filter table 2. SO filter should always come from Table2. The one on one side 

To reduce the value in slicer use a measure from table 1(Measure not column) in visual level filter of slicer of table 2 and check for not blank

If you want count or table 2 same as table one

Countrows(Summarize(Table1, Table2[PN]) )

Table 1 has to involved