Forum Discussion
Same measure in the same table visual giving different result
- Anonymous9 months ago
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.
ErikWarming , I am assuming no Dynamic string formatting is used at Measure or calculation group level
https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/
The same is available in the calculation group for some time and can cause issue of not done properly
You assume correctly. Since its a preview features and this is an old established model, I didn't even think to mention it.
To my knowledge there are no preview features in this model