Forum Discussion
Fundamental Data Model Relationship Question
- 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.
- Is there any Measure in your Table Visual?
mwegener , Anonymous
Here is an example of my Table Visual. There are more records to the left that you can't see but those are descriptive fields. You can see in the screenshot the correct record with some more fields populated with values. The relationship between the Fact and Dim and bringining in the Schedule Dim Key into the Table Visual is causing the record to then explode and repeat as many times as there are Dim records.
- Could you post the DAX statements from the Measure "Production Qty ( Date-....)" and "Use in COS OEE Calc"?