HELP BUILDING RELATIONSHIPS

[Syndicate_Admin]

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

[Anonymous]

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]

Any suggestions??

[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]

Actually, 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.