Forum Discussion

New Member

3 years ago

Solved

Creating Relationships

My datas seem not to be working together. Please what's the best way to create relationships between datas. Thanks

Tips and Tricks

Anonymous
3 years ago
Hi John03

When you create between tables, you need to notice that, there can only be one active filter propagation path between two model tables, if the filter is inactive, you can use USERELATIONSHIP DAX function, you can refer to the following link:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand#make-this-relationship-active

USERELATIONSHIP function (DAX) - DAX | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

New Member

3 years ago

Thanks for sharing this I was able to create some relationships but when I want to get my report I still get some random figures.