Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hola, necesito que me ayuden con algo por favor, estoy intentando mostrar el resultado de un divide entre dos medidas que creé pero el valor porcentual siempre me sale 100%. Muchas gracias
Solved! Go to Solution.
Hola @Dajakda ,
¿Editaste el formato de la medida que solías tener número decimal y decimal 2 como se ve en la imagen? Porque según tu cálculo, el valor es 0,55. Si el valor decimal es 0 en lugar de 2, lo percibe como 1 y devuelve 100%.
Kind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |
Hi @Dajakda ,
Thanks for @uzuntasgokberk and @LuizKoller reply, that's really helpful!
@Dajakda According to your description, the correct result seems to be rounded up, and I suggest you try @uzuntasgokberk method, adjust the number of decimal places, or use the ROUND function.
Measure 3 = ROUND([Measure 2]/[Measure],3)
If the above method doesn't work, I suggest you provide a link to a pbix file with the same problem, it's hard for me to determine what's going on until I see your file.
Best regards,
Mengmeng Li
Hello!
Theres no filters applied in left (only to the visual) pannel that can affect results?
Hello @Dajakda,
No olvides abrir los valores de coma.
Kind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |
Hola, el error es en la fórmula como tal, el cálculo no funciona o no se muestra el resultado correcto
Hola @Dajakda ,
¿Editaste el formato de la medida que solías tener número decimal y decimal 2 como se ve en la imagen? Porque según tu cálculo, el valor es 0,55. Si el valor decimal es 0 en lugar de 2, lo percibe como 1 y devuelve 100%.
Kind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |
User | Count |
---|---|
25 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
29 | |
13 | |
13 | |
10 | |
6 |