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.
Could you post the DAX statements from the Measure "Production Qty ( Date-....)" and "Use in COS OEE Calc"?
There's DAX formula behind the "Production Qty..." field but there isn't for the "Use in COS OEE Calc". The "Use in COS OEE Calc" is a field that contains either 1 or 0 that is already set and being pulled from the Plant Schedule Dim table into the Table Visual.
Production Qty (Date-PlantNum-PlantType-ProdLine-Shift) = CALCULATE(SUMX('HANA Production Fact','HANA Production Fact'[Production Quantity]),ALLEXCEPT('HANA Production Fact','HANA Production Fact'[Production Date], 'HANA Production Fact'[Plant], 'HANA Production Fact'[Plant Type],'HANA Production Fact'[Production Line and Line Type], 'HANA Production Fact'[Shift]))
- 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.
- This measure ignores (ALLEXCEPT) the relation and creates foreach combination a result.