Forum Discussion
Multi fact problem
In this scenario, what do you mean " 'Date d'analyse' is a date a few days before the 'Date de facture'." If this just a date to filter corresponding fact table, which means there's no direct relationship between 'Ventes' and 'Analyses', you should build date dimension into a common dimension.
" Power BI can't handle more than one filtering path"
You are correct. You can only keep one path between two tables based on relationship. So it's better to make "Single" cross filter direction between those common dimensions and fact tables.
Regards,
In this scenario, what do you mean " 'Date d'analyse' is a date a few days before the 'Date de facture'." If this just a date to filter corresponding fact table, which means there's no direct relationship between 'Ventes' and 'Analyses', you should build date dimension into a common dimension.
" Power BI can't handle more than one filtering path"
You are correct. You can only keep one path between two tables based on relationship. So it's better to make "Single" cross filter direction between those common dimensions and fact tables.
Regards,
Thanks to both of you, v-sihou-msft and Greg_Deckler. Like you said, what I needed was a common date dimension between the 2 fact tables.