Forum Discussion

RaedHussein's avatar
RaedHussein
New Member
5 years ago
Solved

Count item names

Hey everyone I Have a selling table that every time I sell an item it updated new row with the item name and selling price and some other columns, I want make a new table that contains 2 columns o...
  • _adamdosso's avatar
    _adamdosso
    5 years ago

    IN DAX, create a new table 

     

    NEW_TABLE = SUMMARIZE(TABLE_NAME,
                                                 ITEM_COLUMN_NAME,
                                                 "UNITS_SOLD", COUNTROWS(TABLE_NAME)
                                                  )
     
    You can do it with Power Query too
RaedHussein's avatar
RaedHussein
New Member
5 years ago

Hi AIP, thanks for helping.

I Prefer Dax.

I hope you can help with all I need>>

let us say I have these 2 tables on an Excel file


The first table on the right is for calculating the cost for every item depending on the kind of material

And the second table on the left is for sold items with details of the buyer.

I need to calculate the material cost of sold items for each product, in a way that I can use a filter to know the cost of each material.

So there are products costs and materials costs of sold product 





AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

RaedHussein 

Can you share the tables in an Excel file so that the contents can be readily copied? You can upload a file by sharing the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).

 

Plus can you show an example of the output that you are looking for, be it in a table or in a visual?

 

Do not mark the question solved until it actually is.

 

 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

Contact me privately for support with any larger-scale BI needs, tutoring, etc.