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.
Make a fast try and remove the Measure "Production Qty (Date-PlantNum-PlantType-ProdLine-Shift)" from the table visual.
I removed the field "Production Qty (Date-PlantNum-PlantType-ProdLine-Shift)" from the Table Visual and that shrunk the records down to one. Why would this particular field I removed cause the records to repeat in the Table Visual? I would expect I could add this field to the Table Visual without experiencing any odd behaviors.