Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Relationship not working

I created a relationship between two tables . One column has unique values and the other one has duplicate values. Both has same data type , relation cardinality is many-to-One . Relation is active but its not working and not returning the exact result. What can be the issue . I need to finalize the reports but they arent working for me .


This is the snapshot of model. Please help me to resolve this issue asap 

Solution Supplier
Solution Supplier

Try turning cross-direction filtering in one direction from user table to transasction log table.

Please mark my solution as accepted if it works.

i tried it didnt work too


Can you share exact error you are facing or sample data with expected output?



Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors