Forum Discussion

Pablo_ace's avatar
Pablo_ace
Regular Visitor
1 year ago
Solved

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 ide...
  • Irwan's avatar
    1 year ago

    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's avatar
    Anonymous
    1 year ago

    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.