Power BI Relationship Not working

[dilkushpatel]

Hi,

I have two tables which has ColumnX and in both table it is not unique

So I created calculated table with distinct value of ColumnX and created 2 way relationship with both tables

however when i add columns from those 2 tables in Power BI tablix it is not able to find relationship between this two table?

Shouldn;t it find it based on relationships I created?

Thanks,

Dilkush

[TomMartens · Accepted solution]

Hey,

can you please make a screenshot from the relationship view of your data model.

I assume that you either referring to the table or matrix view by mentioning "Power BI tablix"?

Regards,

Tom

[dilkushpatel]

Looks like it is working now!!!

may be temporary glitch!!!

Thanks for quick response