Two fact tables for same dates table

@pedroccamara,

If you keep the relationship inactive, you will need to use USERELATIONSHIP in your measures . The alternative is to delete the inactive relationship, and use TREATAS in your measures. Here are some links for each of these.

https://info.enterprisedna.co/dax-function-guide/userelationship/

https://info.enterprisedna.co/dax-function-guide/treatas/

Thanks
Jarrett

1 Like