Forum Discussion
Multiply subtotals between 2 matrix depending on different categories
Hi, OscarDOSSANTOS
Because you did not establish a relationship between the two tables, So there is a problem.
You need to create two table and use the field in your table visual instead of original table field(country and product), then you can get the correct value.
Like this:
Table = DISTINCT(Forecast[Country])Table 2 = DISTINCT(Forecast[Product])Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,Community Support Team _ Janey
Community SupportHi, OscarDOSSANTOS
Because you did not establish a relationship between the two tables, So there is a problem.
You need to create two table and use the field in your table visual instead of original table field(country and product), then you can get the correct value.
Like this:
Table = DISTINCT(Forecast[Country])Table 2 = DISTINCT(Forecast[Product])
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Thank you so much! It works perfectly! I just find another difficulty I hope you can help me.
For every product there is specifications 1 and 2 that we can see from the past data. But the forecast doesn't include the specifications and I would like also to forecast the specifications based on Past data. To better understand:
Thank you so much! I hope I am clear enough, if not feel free to contact me.
Here the link with the new Power bi:
https://drive.google.com/file/d/1N1rIa68s1gjcGzlEkaqo_4wLE5k4r7r1/view?usp=sharing
Have a great week-end!
- v-janeyg-msft
Hi, OscarDOSSANTOS
Sorry, I tried to understand but there were difficulties. I am confused about your description, but it seems to be another big problem. I suggest you open a new post and explain it in detail so that we can help you soon.
Best Regards,
Community Support Team _ Janey