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],...
Need Help
Show and Tell
  • 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.

     

dotykier's avatar
dotykier
Icon for Advocate I rankAdvocate I
7 months ago

As others have said, this indeed appears to be some issue with Power BI Desktop's visual query generation.

Could you try to capture and share the DAX generated for the visual (using the "Performance Analyzer" view in Power BI Desktop)? Perhaps the query itself reveals what is going on. If nothing obvious stands out in the query, please also try to run that same query in DAX Studio and let us know the results.