Filtrar

[Pablo_ace]

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

[Irwan · Accepted solution]

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.

[Anonymous · Accepted solution]

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.

[Irwan · Accepted solution]

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.