Forum Discussion

AKirk's avatar
AKirk
Regular Visitor
2 years ago
Solved

Measure in graph returns inconsistent results when published to Service

I have an issue where a graph that works fine in Desktop breaks when published to the service. Here is what it looks like in the desktop app: And here is what the same graph looks like when...
Need Help
  • AKirk's avatar
    AKirk
    2 years ago

    I believe I have found the issue. It appears to be a case of auto-exist making assumptions, as detailed here:

     

    https://www.sqlbi.com/articles/understanding-dax-auto-exist/

     

    Setting filters on fields outside the summary table makes the results consistent between the desktop app and the service. The original data set uses references to other tables in a couple areas, which happen to be the areas I need to filter by.

AKirk's avatar
AKirk
Regular Visitor
2 years ago

I believe I have found the issue. It appears to be a case of auto-exist making assumptions, as detailed here:

 

https://www.sqlbi.com/articles/understanding-dax-auto-exist/

 

Setting filters on fields outside the summary table makes the results consistent between the desktop app and the service. The original data set uses references to other tables in a couple areas, which happen to be the areas I need to filter by.