Forum Discussion
Diferencia de %
Se crea un medidor y con ese medido arroja 3 diferentes resultados y solo sucede en un solo mes.
5 Replies
- rajendraongole1
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.
0. Formula DAX
1.Este calculo es el correcto
2. Cálculo incorrecto e incongruente en otro objeto visual, con la misma medida
3. Cálculo incorrecto e incongruente en otro objeto visual, con la misma medida
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
rohit1991To resolve the percentage discrepancy for one month in Power BI:
- Check Formula: Ensure % Margen Neto = DIVIDE(CALCULATE([Utilidad Neta]), CALCULATE([Utilidad Bruta])) is consistent.
- Inspect Data: Filter the problematic month to check for irregularities in Utilidad Neta or Utilidad Bruta.
- Aggregation: Verify correct grouping by time dimensions (e.g., Fecha, Año).
- Relationships: Ensure proper relationships in the data model.
- Visual Settings: Confirm consistent summarization in visuals.
Aun no queda con esta solución....
