Forum Discussion

stefani_vileva's avatar
stefani_vileva
Resolver II
4 years ago
Solved

Summarization

Hello everyone,   I am using the simple summarization of one column, but for some of the rows I have sum and for some they are missing. I have attached a screenshot of the example. The one that is ...
Need Help
  • Syndicate_Admin's avatar
    Syndicate_Admin
    4 years ago

    You can review the following:

    * Try using the dax SUMX function and not the SUM function

    * Check that relationships have and follow a coherence, even a tilde can be taken as different in relationships.

    * Check the format of the numbers, these usually bring spaces or have some ,. different.

    * Is some summary from excel loaded in Power BI a table with sparse data that does not follow a relationship or order of data? If so, you should check the Query that meets the information quality parameters.

    *No need to show the data! just make an example and change the names so you can understand your problem in depth

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

You can review the following:

* Try using the dax SUMX function and not the SUM function

* Check that relationships have and follow a coherence, even a tilde can be taken as different in relationships.

* Check the format of the numbers, these usually bring spaces or have some ,. different.

* Is some summary from excel loaded in Power BI a table with sparse data that does not follow a relationship or order of data? If so, you should check the Query that meets the information quality parameters.

*No need to show the data! just make an example and change the names so you can understand your problem in depth