Forum Discussion
Reference to a dimension table after filtering
Hello everybody, I have a DAX challenge here and hope anybody can help me out as I am unable to solve it. My datamodel based on live-connect is a star schema looking like this: T...
daXtreme
Solution Sage
Solution SageYou should not create models with 1-1 connections between tables. Please consolidate into one single table because this is exactly what a 1-1 connection means: the tables are in fact one table.
oh sorry, now I know what you mean, in fact these are 1:n (dimension to fact) relationships.
- daXtreme
Your model says something to the contrary... On top of that, it shows the relationships have two-way filtering enabled on them, which also should not be used lightly, only in certain well-defined circumstannces.