Forum Discussion
Filtrar órdenes
COUNTROWS(VALUES([Order ID]))
Or use the implicit measure "Count (Distinct)" on the Order ID column.
Super UserPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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). Yo necesito identificar la cantidad de ventas 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 |
- lbendlin
COUNTROWS(VALUES([Order ID]))
Or use the implicit measure "Count (Distinct)" on the Order ID column.