Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 invoice numbers and their corresponding SKU's, from which i calculated the no of SKU's per invoice which is shown in the following table:
Invoice No | SKU Count |
A1001 | 22 |
A1002 | 23 |
A1003 | 23 |
A1004 | 24 |
A1005 | 25 |
A1006 | 26 |
A1007 | 26 |
A1008 | 26 |
A1009 | 27 |
A1010 | 28 |
A1011 | 28 |
Now, what I'am struggling with is the no. of invoices per SKU count, for eg:
23 SKU's have been billed twice and 26 SKU's have been billed thrice.
How can I calculate the no of invoices per SKU count?
Please help
Solved! Go to Solution.
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> )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
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
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> )
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Thanks @LivioLanzo,
I created a table using:
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>?
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |