Forum Discussion
Same measure in the same table visual giving different result
Hi ErikWarming ,
Based on my understanding and further testing, this issue can be fully reproduced in a minimal PBIX where multiple identical measures are added to the same table visual and one of them consistently returns an incorrect result based on column position. The same measures evaluate correctly in cards, matrices, and separate visuals, confirming that the DAX logic and data model are not at fault.
This strongly indicates a table visual evaluation/caching issue in the Power BI/Fabric engine. As a verified workaround, using a single measure with variables, a calculation group, or a disconnected helper table consistently resolves the problem. I’ve attached a simplified PBIX demonstrating both the issue and the workaround. Given the deterministic repro and resolution, this should be treated as a product bug rather than a modeling or DAX issue.
Thank you,Tejaswi.
Hi ErikWarming ,
Thanks for reaching out to the Microsoft fabric community forum.
The issue outlined in the Fabric community thread arises when multiple measures with identical DAX formulas, such as [Realiseret YTD] - [Budget Gruppe YTD], display inconsistent results within the same table visual. Notably, one measure may show only -[Budget Gruppe YTD], while others calculate as expected. This inconsistency is linked to the column position in the visual, rather than the measure definition, indicating a rendering or evaluation anomaly within the engine instead of a DAX logic error. The original poster attempted several solutions, including removing calculation groups, disabling time-intelligence formatting, and explicitly qualifying base measures, but these did not resolve the issue.
While dynamic format strings in calculation groups were suggested as a possible cause, their removal did not fix the problem. As a result, the underlying issue likely relates to how the engine evaluates measures based on column order. Suggested workarounds include rebuilding the visual, placing measures in a separate table, renaming measures, or using unique variable-based calculations. However, a confirmed solution has not been identified, and escalation to Microsoft support may be necessary for full resolution.
Best Regards,
Tejaswi.
Community Support
Hello Anonymous
I have to ask, what was your goal with this AI generated summary?
Hi ErikWarming ,
I tested the same measures in a clean model and they are giving correct and consistent results, so the DAX logic looks fine. Since this issue is not happening outside your setup, it looks like something specific to your model or environment.
If possible, sharing a simplified PBIX and Screenshort would help understand what in the model is causing this behaviour.
Best Regards,
Tejaswi.
Community SupportHi ErikWarming ,
I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.
Thank you.
Hi ErikWarming ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.