Forum Discussion
Filtrar
- 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.
- Anonymous1 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.
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.