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.
Etiquetas de fila | Promedio de KM | Recuento de paradas |
4583383 | 350.83612 | 11 |
4623383 | 408.77236 | 9 |
4633383 | 347.61744 | 10 |
4643383 | 214.04222 | 13 |
Grand Total | 320.8574842 | 43 |
suma 4 avg kms | 1321.26814 | |
suma dividida por recuento | 30.72716605 |
Solved! Go to Solution.
@salman_ali estas serán dos medidas diferentes, una Medida de Kms Promedio y la 2a será Medida1
AVG Kms Measure = AVERAGE(E3table_1[KM])
Measure1 =
IF ( HASONEVALUE(E3table_1[ManInd]),
[AVG Kms Measure],
SUMX(
SUMMARIZE ( VALUES(E3table_1[ManInd]), E3table_1[ManInd], "AvgKms",[AVG Kms Measure] ),
[AvgKms]
)
)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hola @salman_ali ,
Puede copiar y pegar sus datos de muestra aquí directamente. Por favor, comparta sus datos de muestra y el resultado excepto para mí si no tiene ninguna Información Confidencial. Cargue sus archivos en One Drive for Business y comparta el enlace aquí.
Hola
¿Funcionan estas medidas?
AVGKMS - PROMEDIO(E3table_1[KM])
Measure1 á if(hasonevalue(E3table_1[ManInd]),AVGKMS,SUMX(SUMMARIZE(VALUES(E3table_1[ManInd]),E3table_1[ManInd],"ABCD",[AVGKMS]),[ABCD]))
Espero que esto ayude.
Lo siento Ashish, esto me está dando error
Hola
¿Funciona esto?
AVGKMS - PROMEDIO(E3table_1[KM])
Measure1 á if(hasonevalue(E3table_1[ManInd]),[AVGKMS],SUMX(SUMMARIZE(VALUES(E3table_1[ManInd]),E3table_1[ManInd],"ABCD",[AVGKMS]),[ABCD]))
Si no es así, comparta el enlace desde donde puedo descargar el archivo PBI y mostrar claramente el objeto visual donde mi medida no funciona.
Lo siento por desgracia no puedo compartir el archivo, pero el error viene cuando i tipo Measure1 .
¿tiene que haber algo después de
Hola
Lo siento, pero no puedo ayudar si no puede compartir ningún dato.
Entiendo, gracias
@salman_ali estas serán dos medidas diferentes, una Medida de Kms Promedio y la 2a será Medida1
AVG Kms Measure = AVERAGE(E3table_1[KM])
Measure1 =
IF ( HASONEVALUE(E3table_1[ManInd]),
[AVG Kms Measure],
SUMX(
SUMMARIZE ( VALUES(E3table_1[ManInd]), E3table_1[ManInd], "AvgKms",[AVG Kms Measure] ),
[AvgKms]
)
)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Gracias, esto funcionó
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 |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |