Solved: Maximos

carlosayala_9 · ‎11-18-2022

Buenas tardes!

Necesito hacer una medida que me acomode en una tabla donde tenga los meses en fila (lo tengo en filtros) y que me acomode al lado el colaborador que mas vendio y la cantidad.

Se agradece la ayuda!

amitchandak · ‎11-18-2022

@carlosayala_9 , You need a measure like

maxx(TOPN(2, allselected('Table'[collaborator]), [Net Sales],desc), [collaborator])

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

carlosayala_9 · ‎11-29-2022

gracias! funciono

amitchandak · ‎11-18-2022

@carlosayala_9 , You need a measure like

maxx(TOPN(2, allselected('Table'[collaborator]), [Net Sales],desc), [collaborator])

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Maximos

Helpful resources

Power BI Monthly Update - September 2024

Microsoft Fabric & AI Learning Hackathon

Fabric Community Update - September 2024