Forum Discussion

Danapa's avatar
Danapa
Frequent Visitor
9 years ago

Couldn't get the simple sum function for a column

Hi,  I have this sales table with the sales amount as one of the columns. And I have the date as a column. The sales table has the relationship connected to a calendar table. I need to total the sal...
Need Help
BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Do you have any filters(page level/visual filters) in your report, Any slicers that are active as well. If so, can you please cancel those filters to get the accurate results. 

Danapa's avatar
Danapa
Frequent Visitor
9 years ago

Thanks! I've cleared the slicer. It got self fixed today when I reopened it. Power BI had a glitch or something. But I do have an issue which make me wonder if it has something to do with the glitch. That is, after I imported the sales data in queries, apply and close. The content data of the table doesn't show up in the data section. It's all grey there (see the photo below). I can go back to the queries to see the data, and I'm able to use the sales data when I create visual reports. I don't know why it happened this way. Is it because the file size? The data section just won't store and show up the content. Appreciate if your experience can explain this for me!

 

  • MEhrenmueller's avatar
    MEhrenmueller
    Most Valuable Professional
    9 years ago

    Looks weird.

     

    Have you tried to close the file or Power BI and reopen or tried to restart you client?

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    That does happen sometimes in Data view when your file is not saved or the query changes has not been applied. After reopening and resaving the file fixes the issue. if you would like to check the data/columns ,you can always  go to the Query editor.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi Danapa,

     

    I remembered I met the same issue when I used the Power BI Desktop version 2.40.4554.361, but after I updated to the new version

    2.40.4554.463, I didn't encounter this issue. Please update the desktop to this new version to check if the issue persists: https://www.microsoft.com/en-us/download/details.aspx?id=45331.

     

    Best Regards,
    Qiuyun Yu

    • Danapa's avatar
      Danapa
      Frequent Visitor
      9 years ago

      Thank you for the info. I updated the version and the issue still persists. :smileysad:

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        9 years ago

        Hi Danapa,

         

        Did the data grayed out in Data tab frequently or intermittently in latest desktop version?

         

        Best Regards,
        Qiuyun Yu