Forum Discussion

ErikWarming's avatar
ErikWarming
Frequent Visitor
9 months ago
Solved

Same measure in the same table visual giving different result

The problem I have a problem that I don’t know how to diagnose or solve any more. My client has two measures and want to see the difference between the two. A simple diff = [measure1] – [measure2],...
  • Anonymous's avatar
    Anonymous
    8 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.