Creating Relationships

[John03]

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

Thanks

[Anonymous · Accepted solution]

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-thi...

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.

[John03]

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. 

[Anonymous]

Try to create a Star Schema with Dim/Fact Tables

Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn

Understand star schema and the importance for Power BI - Power BI | Microsoft Learn