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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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.

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

 

 

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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