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> )
Hi
Anonymous
you 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]