Forum Discussion
Filtrar
Hola! Dejo este ejemplo: en este sistema de ventas, tengo 9 productos vendidos (Row ID) en 4 ventas realizadas (hay solo 4 Order ID distintos, ya que hay órdenes de múltiples productos). Necesito identificar la cantidad de ventas (órdenes) realizadas (en un archivo de 9800 productos vendidos)
| Row ID (Enumeración de productos vendidos) | Order ID (ID de la venta) |
| 1 | CA-2017-152156 |
| 2 | CA-2017-152156 |
| 3 | CA-2017-138688 |
| 4 | US-2016-108966 |
| 5 | US-2016-108966 |
| 6 | CA-2015-115812 |
| 7 | CA-2015-115812 |
| 8 | CA-2015-115812 |
| 9 | CA-2015-115812 |
hello Pablo_ace
i might be misunderstood your need since i used google translate.
if you need to count order id, you can use measure with DISTINCTCOUNT().
it will check all unique value in 'Order ID" column.
Another way is using SUMMARIZE() or SUMMARIZECOLUMN() if you can create new table.
Hope this will help.
Thank you.
Hi Pablo_ace
If you want to calculate the number of sales orders, you can follow Irwan's reply using DISTINCTCOUNT().
If you want to calculate the number of products sold in each sales order, you can use COUNTROWS(). Like the following:Number = COUNTROWS('Table')Please correct me if I'm misunderstanding your needs.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
hello Pablo_ace
i might be misunderstood your need since i used google translate.
if you need to count order id, you can use measure with DISTINCTCOUNT().
it will check all unique value in 'Order ID" column.
Another way is using SUMMARIZE() or SUMMARIZECOLUMN() if you can create new table.
Hope this will help.
Thank you.
Hi Pablo_ace
If you want to calculate the number of sales orders, you can follow Irwan's reply using DISTINCTCOUNT().
If you want to calculate the number of products sold in each sales order, you can use COUNTROWS(). Like the following:Number = COUNTROWS('Table')Please correct me if I'm misunderstanding your needs.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.