Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,....
Solved! Go to Solution.
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.] ) ) ) )
Drop both item numner and quantity on the table visual, and on item number, in drop down, select "dont summarize"
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
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.] ) ) ) )
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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Both of those tables picture are with the item no. and No_ not summerized already
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |