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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
curr00
New Member

Diferencia de %

curr00_0-1737679688149.png

Se crea un medidor y con ese medido arroja 3 diferentes resultados y solo sucede en un solo mes.

5 REPLIES 5
rohit1991
Super User
Super User

To resolve the percentage discrepancy for one month in Power BI:

  1. Check Formula: Ensure % Margen Neto = DIVIDE(CALCULATE([Utilidad Neta]), CALCULATE([Utilidad Bruta])) is consistent.
  2. Inspect Data: Filter the problematic month to check for irregularities in Utilidad Neta or Utilidad Bruta.
  3. Aggregation: Verify correct grouping by time dimensions (e.g., Fecha, Año).
  4. Relationships: Ensure proper relationships in the data model.
  5. Visual Settings: Confirm consistent summarization in visuals.

Did it work? ✔ Give a Kudo • Mark as Solution – help others too!

Aun no queda con esta solución....

rajendraongole1
Super User
Super User

Hi @curr00  - can you please share the sample data by removing the sensitive information with expected output and also share the DAX formula for the measure or describe the data model structure to help narrow down the cause of the discrepancies.

 

It helps to analyze.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





0. Formula DAX

curr00_4-1738250580593.png

 

1.Este calculo es el correcto

curr00_0-1738250105534.png

 

2. Cálculo incorrecto e incongruente en otro objeto visual, con la misma medida

curr00_2-1738250287772.png

 

3. Cálculo incorrecto e incongruente en otro objeto visual, con la misma medida

curr00_3-1738250496381.png

 

 

Anonymous
Not applicable

Hi @curr00 ,

You only provided a screenshot of your visual creation result, which may not be helpful for us to understand your problem. We hope that you can provide your data model (sample data in each table, the relationship between tables, etc.) and the DAX you use, which will help us test and find a solution. Thank you!

Best Regards,
Dino Tao

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.