Forum Discussion
Average SKU per Invoice calculation
Hello All, I need help calculating the average SKU per invoice, the calculation of which is= (SKU Sold Per Invoice X No of Invoices)/Total No of Invoices I have a transaction table with invo...
Hi
Anonymousyou need to create a calculated table which returns the table you're showing below. Then drop the SKU Count on the rows section of a matrix and add a measure which does COUNTROWS( <the_calculated table_you_created> )
Thanks LivioLanzo,
I created a table using:
Table = SUMMARIZE('Transaction','Transaction'[Inv No.],"Count items",COUNT('Transaction'[ITEM]))
Now, I created a measure:
Count=COUNTROWS(Table)
When i multiply them in a measure, Count items * count, I obtain the following:
| Count items | Count | Count items*Count |
| 22 | 1 | 22 |
| 20 | 1 | 20 |
| 19 | 5 | 475 |
| 18 | 2 | 72 |
There is a duplicacy taking place at the time of multiplication.
How do i remove that?
Hi Anonymous
how are you performing your multiplication>?
LivioLanzo, I created a measure:
Measure = SUM('Table'[Count items])*[Count]