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.
Tengo una tabla que tiene muchas columnas. (fecha, Usuario, Importe, etc.). Necesito encontrar al usuario que tiene la mayor cantidad independientemente de cualquier otra columna (fecha, etc.).
La salida será GHI y 1000
Nombre | Cantidad |
Abc | 100 |
Def | 200 |
Ghi | 1000 |
Jkl | 350 |
Solved! Go to Solution.
lastnonblankvalue(Table[Amount], max(Table[Name]))
seleccionar con Importe no resumido. De lo contrario, cree un rango y filtre en 1 o use el top 1
ventas á sum(Tabla[Importe])
Rank á RANKX(all(Table[Name]),[Sales])
Rank Top 1- CALCULATE(if([Rank]-,[Sales],BLANK()) ,VALUES(Table[Name]))
Rank Top 1 á sumx(VALUES(Table[Name]),if([Rank]-1,[Sales],BLANK()) )
Top 1 Rank á CALCULATE([Sales],TOPN(1,all(Table[Name]),[Sales],DESC),VALUES(Table[Table]))
Para rango Consulte estos enlaces
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...
Rango 2o superior á sumx(filter(VALUES(Geography[City]),[Rango de la ciudad]-2),[Ventas] )
lastnonblankvalue(Table[Amount], max(Table[Name]))
seleccionar con Importe no resumido. De lo contrario, cree un rango y filtre en 1 o use el top 1
ventas á sum(Tabla[Importe])
Rank á RANKX(all(Table[Name]),[Sales])
Rank Top 1- CALCULATE(if([Rank]-,[Sales],BLANK()) ,VALUES(Table[Name]))
Rank Top 1 á sumx(VALUES(Table[Name]),if([Rank]-1,[Sales],BLANK()) )
Top 1 Rank á CALCULATE([Sales],TOPN(1,all(Table[Name]),[Sales],DESC),VALUES(Table[Table]))
Para rango Consulte estos enlaces
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...
Rango 2o superior á sumx(filter(VALUES(Geography[City]),[Rango de la ciudad]-2),[Ventas] )
How it will handle the situation when 2 rows have same amount
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 |