Forum Discussion
Syndicate_Admin
Administrator
AdministratorHELP BUILDING RELATIONSHIPS
I'm making my first weapons in Power BI I need to get a report of items sold by customer. Something like Customer Name - Item Name - Total Amount Sold The tables I have are the ones I detai...
Hi Syndicate_Admin ,
Can you provide more details on how you are attempting to calculate totals by project? Specifically, are you using DAX metrics for this calculation, and if so, can you share the expression you are using?
Best Regards,
Adamk Kong
Syndicate_AdminAdministrator
AdministratorHello. I'm not using DAX. I'm just using the fields from the tables.
| SALES | |||
| NRO | DATE | CUSTOMER | TOTAL |
| 1 | 12/02/2024 | 1 | 980 |
| 2 | 13/02/2024 | 1 | 390 |
| 3 | 15/02/2024 | 2 | 520 |
| LINES-SALES | |||
| NRO | ARTICLE | QUANTITY | PRICE |
| 1 | 100 | 5 | 100 |
| 1 | 101 | 4 | 120 |
| 2 | 102 | 3 | 130 |
| 3 | 101 | 2 | 120 |
| 3 | 102 | 1 | 130 |
| 3 | 103 | 1 | 150 |
| ARTICLES | |||
| ARTICLE | NAME | PRE-UNIT | ITEM |
| 100 | ARTICLE 100 | 150 | A |
| 101 | ARTICLE 101 | 125 | A |
| 102 | ARTICLE 102 | 140 | B |
| 103 | ARTICLE 103 | 150 | C |
| PRODUCTS | |||
| ITEM | NAME | ||
| A | ITEM A | ||
| B | ITEM B | ||
| C | ITEM C |