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
how are you performing your multiplication>?
LivioLanzo, I created a measure:
Measure = SUM('Table'[Count items])*[Count]