Forum Discussion

mehdibentorkia's avatar
mehdibentorkia
Regular Visitor
6 years ago

sum is incorrect

hello   I am very new to power bi, please excuse me if I am doing something wrong.   basically i have my table on excel and i uploaded it on power bi but the sum on excel is not the same as when ...
Need Help
mehdibentorkia's avatar
mehdibentorkia
Regular Visitor
6 years ago

What do you mean Agg?

It is set at Sum.

The actual sum is correct but it is not correct for the actual categories. 

its like it is not picking up all the sales for each category, for example the sales should be at 10000 euros, it is only showing 3000 euros. 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

As a first step. Check the count of rows in powerbi to ensure all rows are loaded.

If possible please share a sample pbix file after removing sensitive information.Thanks.

  • mehdibentorkia's avatar
    mehdibentorkia
    Regular Visitor
    6 years ago

    Hello

     

    I realised that alot of the rows are missing.

    Please see screenshot how some of the ID codes are missing.

    Sorry for not sharing the file, its just that the data (numbers) it self is sensitive.

     

    https://ibb.co/Yf9jPMZ

    • mehdibentorkia's avatar
      mehdibentorkia
      Regular Visitor
      6 years ago

      here is a clearer example and comparison between the excel data and PBI data.

      As you can see the data in yellow is missing and the ones in green are appearing on PBI. 

       

      https://ibb.co/wMWFbXC

      • v-lili6-msft's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        hi  mehdibentorkia 

        Please check you have the filter applied anywhere eg. in edit queries or page/report level filter.

        if possibel, could you please remove sensitive data columns and share it for us have a test?

         

        Regards,

        Lin