Forum Discussion
Solved
Multi fact problem
Hello, I am relatively new to star schema design, Power BI and its best pratices, especially when there are multiple fact tables on the same report. I am struggling a little bit with the foll...
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,
Yes, you would want to have a common date dimension. In fact, you would want common dimensions for all shared dimensions between your fact tables in general.