Forum Discussion
Fundamental Data Model Relationship Question
Hello, I've created a data model with a Fact table and Dim table. I've also create a relationship(1:M) from the Dim to the Fact table. Now, when a start creating a Table Visual for my "spot-check...
- This measure ignores (ALLEXCEPT) the relation and creates foreach combination a result.
Hi Anonymous ,
could you post a screenshot of your data model view?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
mwegener , Anonymous
Here is the data model screenshot. I'll also add that there will be some cases that there's no Key field value from the Dim table that matches the Key field value in the Fact table. All the Key field values from the Dim table will find a matching Key field value in the Fact table, just not the other way around.