Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |