Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

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 detai...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    2 years ago

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

    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's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    2 years ago

    Any suggestions??