Forum Discussion
Solved
link columns
Hello everyone, I have an issue. I explain myself with an example. Ex: I sell burgers for the same price but some client do not want pickles for example. Let's say that I sold 100 burgers for j...
Is that how your current data is stored? What can you tell me about the related table? What does the desired result look like?
Hi Anonymous,
| Month | Year | Company | Country | Burgers sold | Buns | Steaks | Cheese | Pickle |
| 1 | 2016 | X | FRA | 5920 | 5920 | 5920 | 5328 | 4144 |
| 2 | 2016 | X | FRA | 6343 | 6343 | 6343 | 5709 | 4440 |
| 3 | 2016 | X | FRA | 2439 | 2439 | 2439 | 2195 | 1707 |
| 4 | 2016 | X | FRA | 6534 | 6534 | 6534 | 5881 | 4574 |
| 5 | 2016 | X | FRA | 7762 | 7762 | 7762 | 6986 | 5433 |
| 6 | 2016 | X | FRA | 2346 | 2346 | 2346 | 2111 | 1642 |
So basically, I want to show that for 5920 burgers sold in 01/2016, 5236 and 4144 cheese have been used.
The thing is that I have a pie chart (link between 2 tables) with my suppliers and, as we do not receive bill from them every month, Power BI believes that any cheese or pickles have been used. So I'd like to know if it is possible.
Thanks :)
Is that how your current data is stored? What can you tell me about the related table? What does the desired result look like?