Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Syndicate_Admin
Administrator
Administrator

HELP 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

SERGLE_0-1709647230783.png

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

SERGLE_1-1709647391647.png

4 REPLIES 4
v-kongfanf-msft
Community Support
Community Support

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

Any suggestions??

Hello. I'm not using DAX. I'm just using the fields from the tables.

SERGLE_0-1709747575277.png

SALES
NRODATECUSTOMERTOTAL
112/02/20241980
213/02/20241390
315/02/20242520
LINES-SALES
NROARTICLEQUANTITYPRICE
11005100
11014120
21023130
31012120
31021130
31031150

ARTICLES
ARTICLENAMEPRE-UNITITEM
100ARTICLE 100150A
101ARTICLE 101125A
102ARTICLE 102140B
103ARTICLE 103150C
PRODUCTS
ITEMNAME
AITEM A
BITEM B
CITEM C
Syndicate_Admin
Administrator
Administrator

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors