Forum Discussion

smpa01's avatar
smpa01
Community Champion
8 years ago

Column Value differs in Data and Report View

Hi,

 

I have experienced this for the first time, that a column value has become 0 when the data was orgainsed in Table Visualization. However, when I see it in the Data view it gives me the correct value.

 

Does any one know why it happens and how can I prvent it from happening in Table

 

Need Help

5 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi smpa01,

     

    Can you share the pbix file please? You can delete the confidential parts first.

    I tested it and found two possible types of aggregation could return 0. 

    Column_Value_differs_in_Data_and_Report_View

     

    Best Regards,

    Dale

    • smpa01's avatar
      smpa01
      Community Champion
      8 years ago

      Hi Dale,

       

      Many thanks for getting back to me. I tried and unfortunately could not replicate the same PBIX without deleting the confidential part.

       

      However, by looking at your file, I realized that in the table visualisation the data was summarized. I perormed "Don't summarize" and the cells with 0 value before returned their correct value.I found this very strange though.

       

      You mentioned about two possibilites while aggregating that could return 0. I am guessing that STDEV is one of them. My data was simply summarized and standard deviation was not performed.

       

      Can you please share some insight on what is the other possibility when it returns 0 value.

       

      Thank you.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi smpa01,

         

        That's very strange. I tried but can't find out any possibilities. I don't need the whole file. You can only keep the data that can show up the issue. BTW, please upgrade to the latest Desktop.

         

        Best Regards,

        Dale