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.
