Forum Discussion
Help with correct total
Hi， Anonymous
If so, you can directly change the summary type of each column value, here you can use 'maximum'/'Average'/'Minimum' to get the result you want.
Best Regards,
Community Support Team _ Eason
If you upload your file to one drive / dorp box and share the link I'll happily take a look.
Your first approach is a good start but you need a bridge table to handle the many to many relationship between parts and products.
Eg:
| Part | Model |
|
1 |
A |
| 1 | B |
| 2 | A |
| 2 | C |
That is then a step forward but you'll still then end up with a similar problem to your flat table when you come to agregate as you're dealing with two different granualarities (part level and model level).
Share your file an if possible a bridge table like above and I'll try and help with the model and DAX for measures.
I don't see the option for uploading itself even for one drive 😞
How do I do that please?
If you have the file in one drive you should be able to click share in one drive and create a link that anyone can access. Then just paste link below.
Thank you!
I used goog drive and hopefully, it works!
Here is the link with example dataset for concept purpose:
https://drive.google.com/file/d/1u08xEf1LhetTmZ5c9Hdzxyfh-845PiWv/view?usp=sharing
I worked on the combined table as described above. But I have also included individual tables Table 1 & Tabel 2 along with parts table in case we can link the 2 table with parts directly.
Thanks again for the support!
Hi,
In January, Part A01 was used in Models M1 and M2. So the answer should be 195+195 = 390. What is the problem?
