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 may use SUMMARIZE Function to get a new table. Then you may get the no of invoices per SKU count with the table. For example:
Table = SUMMARIZE ( Table, Table[Invoice No], "SKU Count", [Meaure] )
Regards,
Cherie