Forum Discussion
m-colbert
Resolver III
Resolver IIIPBI Not Applying Relationship between Imported Table and Calculated Table
I have a dimension table called Plant, it has a unique column PlantId. This table relates to 3 other imported fact tables just fine with one-to-many relationship. I created a calculated table in DA...
Deku
Super User
Super UserSince you are trying to join a calculated table and it failing I suspect a circular dependancy is at play. You need to use functions that don't include the SSAS's include blank row, so you can use distinct or allnoblankrow, but not values or all.
See this SQLBI article on the topic