Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Default Summarization Not Working

Hi guys,   I'm having a problem using default summarization. My model has 3 tables, d calendar, d fb ads and fb ads. I've established the following relationship between then:   I've setted...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

    Yes, you can mark your post as Answered if the problem has been resolved. 

    Best Regards
    Community Support Team _ Rena Ruan
    If this post helps, then please consider Accept it as the solution to help the other members find it more.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak Thank for your reply.

 

Unfortunately the problem is still occorring. I was not able to find the Summarization option inside the Visualizations Menu. I remember that in previous versions of PBI Destktop it used to have this option, but, as  I'm using the last version of PBI Desktop, I didn't find the option. 

 

I've checked the 'f fb_ads'[spend] data type using Fields Menu, and it's setted to SUM.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

I can't reproduce your problem. What's the version of your Power BI Desktop? In addition to not being able to use the default summarization function, the menu options in your screenshot are also different from mine: it does not contain any aggregation function options. It is strange... Could you please try to create another visual used another numeric field and check whether the default summarization function can work or not? 

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    First of all, thank for your reply. 

     

    I'm using the 2.87.762.0 64-bit (November 2020) PBI version.

     

    In this report, I've a very similiar table, called 'f g_ads'. Basically, I've the same structure for 'f fb_ads' and for 'f g_ads'.  

     

    In order to provide as much information as possible, I'll include in this reply some screenshots from both of this table, as well as the relasioship of both of than with the 'd calendar'.

     

    • 'f fb_ads'  Table Structure

    • 'f g_ads' Table Structure

    •  Relationship of Tables

     

    I tried to use the default summary for other numeric fields, but even if these fields are set up as integers or decimals, it appears that PBI is treating it as strings, because everyone is exhibiting the same behavior.

     

    All my date come from MYSQL database, and for some tables, when importing, I need to use some SQL JOINs to import only the data that it matters. 

    i.e. 

    SELECT d.* FROM `g_ads_anuncio_dias` d #(lf)INNER JOIN g_ads_anuncios a ON d.anuncio_id = a.id#(lf)INNER JOIN g_ads_grupos g ON a.grupo_id = g.id#(lf)INNER JOIN g_ads_campanhas c ON g.campanha_id = c.id#(lf)WHERE c.conta_id = 3"

     

    And, by doing this, the navigation step causes an error, and in orther to keep importing data, I remove this step from the APPLIED STEPS section on Power Query Editor.

     

    But even the tables that don't need to be JOIN are presenting the same problem

     

    . 

    I do not know what else could be causing this issue.

     

    Best Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous ,

      Sorry I can't reproduce your problem... Could you please try to upgrade the version of your Power BI Desktop to the latest one? Besides that, please try to create a new report file and make a table with below data. Then create a table visual  using value field and check whether you can get the aggregation options normally...

      ID Value
      id1 1
      id2 2
      id3 4
      id4 3

      Best Regards
      Community Support Team _ Rena Ruan
      If this post helps, then please consider Accept it as the solution to help the other members find it more.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous , how are you doing ?

         

        Over the weekend I've made some test in order to understand better the problem.

         

        First I created the table that you suggested inside the current PBI File that I was working on. The problem still happening, and the Value was not summarized. I think that PBI was interpreting Values column as a String. 

         

        Then I've created a new PBI File and insert your suggestion table in it. The problem did not reappear and everything returned to normal.

         

        After validating the issue didn't occours again, I've imported all my tables from my MYSQL database, and the default summarization started to work again. So I'm creating all my model from scratch, and fortunately, the problem is not occuring. 

         

        In all the tests I was working with the same PBI Version: 2.87.762.0 64-bit (novembro de 2020).

         

        Thank for your time and help. Should I mark your last comment as a solution ?

         

        Best Regards,