cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

Obtener los valores de la columna cuando la condición es true

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]))


1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

D_NFOrderID = CALCULATE(selectedvalues('Marckeet License rep1'[NFOrderID]),filter('Marckeet License rep1',
NOT('Marckeet License rep1'[purchaserEmailId])in values('Marckeet License rep1'[userEmailid])))

View solution in original post

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

D_NFOrderID = CALCULATE(selectedvalues('Marckeet License rep1'[NFOrderID]),filter('Marckeet License rep1',
NOT('Marckeet License rep1'[purchaserEmailId])in values('Marckeet License rep1'[userEmailid])))
Syndicate_Admin
Administrator
Administrator

@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

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors
Top Kudoed Authors