Forum Discussion
Multiple fact tables for the same dimensions in tabular
Hi, im making a tabular model to use in Power BI and i have more than one fact table related, (Orders, sales, shippings) and all the tables are related to the Client, Items, Calendar dimensions but I can only use these with one of the fact tables because the tabular model allows me only one active relationship. How can i solve this?
- I am trying not to create multiple sets of dimensions for each table of fact
-everytime that i would like to make reference to a dimension which isnt active use DAX USERELATIONSHIP expression into a measure but what about an item description?
-I also thinking to migrate the project to a multidimensional model but I do not know if I will solve the problem cause I do not have much experience.
I would like to know a better solution from this great community
Thanks! and sorry for my bad English.
- Anonymous4 years agoNot applicable
Hi Maxi,
Did you solve your multifact table issue ?