Forum Discussion
Multiply subtotals between 2 matrix depending on different categories
- 4 years ago
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
Rather difficult to advise on this without seeing your data model. Would you be able to post a sample pbix file, or at least the data components?
As I don't have the option to upload the file, I share a link to download it from my google drive
https://drive.google.com/file/d/1N1rIa68s1gjcGzlEkaqo_4wLE5k4r7r1/view?usp=sharing
Thank you so much!