Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hola
He escrito un DAX para obtener el recuento de ID. Quiero obtener los valores de esas filas de la columna id de orden, Insted of count. ¿Cómo conseguirlo?
Probado con la función selectedvalue, pero solo un valor es visible si hay más de un valor, entonces se queda en blanco.
D_NFOrderID = CALCULATE(count('Marckeet License rep1'[NFOrderID]),NOT('Marckeet License rep1'[purchaserEmailId])in
values('Marckeet License rep1'[userEmailid]))
Solved! Go to Solution.
D_NFOrderID = CALCULATE(selectedvalues('Marckeet License rep1'[NFOrderID]),filter('Marckeet License rep1',
NOT('Marckeet License rep1'[purchaserEmailId])in values('Marckeet License rep1'[userEmailid])))
D_NFOrderID = CALCULATE(selectedvalues('Marckeet License rep1'[NFOrderID]),filter('Marckeet License rep1',
NOT('Marckeet License rep1'[purchaserEmailId])in values('Marckeet License rep1'[userEmailid])))
@anand212 , Prueba como
D_NFOrderID = CALCULATE(count('Marckeet License rep1'[NFOrderID]),NOT('Marckeet License rep1'[purchaserEmailId] en
values('Marckeet License rep1'[userEmailid])))
Hola
No quiero contar desde la medida, quiero los valores de las filas de la columna. De esta manera
NFOrderID |
3104237267 |
2114352274 |
2114352539 |
2114352546 |
2114352396 |
2114352184 |
2114352397 |
3104237270 |
2114352548 |
2114352425 |
2114352310 |
2114352565 |
3104237270 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |