Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI Relationship between two tables

I have 2 tables T1 and T2 and they related to each other using T1(1-*)T2.  Now I wanted to show the rows from T1 where I couldn't find atleast one row in T2.  Using SQL I could write something like...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

You may try to set the 'Cross filter direction' to 'Both' in relationship.

 

Regards,

Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks v-cherch-msft

The Cross filter direction to both is not surving my purpose.