Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Dajakda
Regular Visitor

Error en fórmula DAX

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

 

Dajakda_0-1729185111064.png

 

1 ACCEPTED 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%.

 

uzuntasgokberk_0-1729333875529.png

 

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 |

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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

LuizKoller
Resolver I
Resolver I

Hello!

 

 

Theres no filters applied in left (only to the visual) pannel that can affect results? 

uzuntasgokberk
Super User
Super User

Hello @Dajakda,

No olvides abrir los valores de coma.

 

uzuntasgokberk_1-1729187891214.png

 

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%.

 

uzuntasgokberk_0-1729333875529.png

 

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 |

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.