Creating Relationships

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.