Forum Discussion

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity 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 correc...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Community Champion rankCommunity 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
      Icon for Microsoft Employee rankMicrosoft 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

      • smpa01's avatar
        smpa01
        Icon for Community Champion rankCommunity Champion
        8 years ago

        Hi v-jiascu-msft

         

        I have tried to recreate the issue by keeping only the columns where it returns the 0 value. But I could not succeed. 

         

        For now, I am using"Don't Summarize" as by doing that it shows the correct value. When I apply "Sum" for some cells it turns to 0 but the sum does not take 0's into considertaion.

         

        I am currently using the up-to-date PBI Desktop.

         

        Thanks again.