Forum Discussion
Model and DAX for Volume
many thanks to you.
table : tblproducing is a fact table including all of actual data and other desired data like budget or previous years data to compare and analyze.
table tblproductVol is a also fact table including production volume. what these 2 tables common point is all include produciton line.
tblproduction table provide summary production volume by different production lines by period. however tblproducing need these production volume by production lines and by periods to calculate total cost and others.
but now couldn't get the right volume flexiblly by production line and periods via measure: MonthVolM, we could see that in sheet "Data" range K24:S32, so when using Measure :monthvolm to calculate , couldn't get the expected result.
| Type | Production line | Month | right | wrong |
| act | Gline1 | Jan | 570 | 875 |
| Act | Gline2 | Jan | 351 | 548 |
| act | GHP | Jan | 273 | 417 |
and tblproducing is part of fact data . and if put all of these production volume by production lines by period into tblproducing table, these will be many duplicated data in it. so question is :
1, how to get right produciton volume by production lines and periods rightly when to create measure from tblproducing table?
2, or establish one right or proper relationship to improve these? because couldn't use tblproductvol table some columns and tblproducing table together to calculate or present as there is prompt appeared.