Forum Discussion
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 detail at the end
I made the relationships
SALES (NO) -> LINES-SALES(NO) One to Various
LINES-SALES(ITEM) -> ITEMS(ITEM) Multiple to One
ITEMS(ITEM) -> ITEMS(ITEM) Various to One
And the report that I get is as follows. I can't get him to calculate the total by item correctly. In each Item you put the total of the sales, and not the total of the item
4 Replies
Syndicate_AdminActually, in the first instance I need to get a sales report by line item.
Once this is solved, I estimate that I could make the report of the total amount sold of items, by customer.
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_Admin
Hello. 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 - Syndicate_Admin
Any suggestions??
