Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
yes, You can have more, than one fact table, but you will not be able to build / create a consistent data model. The typical consequence of such data models is many-to-many relationships. A typically is hard to resolve such collisions and suitable approach will be different from one data model to other.
You can send your own data sample to reach better solution
Best regs