Forum Discussion
Sum of selected values
I am trying to create a total with filtering the information to have mutiple total for each seperate item. One colum is an item number which identify the product, the other is the quantity of order. I need to create a table that sums the quantity for each item seperatly.
Example-
colum 1 (Item No.): 76, 76, 76, 50, 50, 23, 18, 17, 16, 16,.....
colum 2 (Quanity): 205, 116, 500, 419, 393, 201, 650, 775,.....
Creates-
colum 1 (Item No.): 76, 50, 23, 18, 17, 16
colum 2 (Quanity): 821, 812, 201,....
You may add a measure as shown below.
Measure = DIVIDE ( SUM ( Table1[Quantity] ), CALCULATE ( SUM ( Table2[Bushel Quantity] ), FILTER ( Table2, Table2[No_] = MAX ( Table1[Item No.] ) ) ) )
6 Replies
- parry2k
Super User
Drop both item numner and quantity on the table visual, and on item number, in drop down, select "dont summarize"
I want each item to have a summerized total quantity, I need it to be in table format. In this picture Item no. and No_ have the same values with mutiple entries for each item. Power Bi summerizes each information from two seperate directquiry databases. I need to take total item quanities shown from the first table and devide it by the total bushel quantities in the second table.
- parry2k
I'm not clear about your request.
So to confirm, you have one table with item numner and quantity column and you want to summarize quantity for each item in a table, correct?
If that is the case, my first reply will do the job.
