Summarization

[stefani_vileva]

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 marked with red is summed, but the yellow and green are not.

Does someone knows why is this happening?

Thanks a lot.

Kind regards,

Stefani

[Syndicate_Admin · Accepted solution]

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

[themistoklis]

@stefani_vileva 

Could you show us the columns and row names as well...?

It is not clear what are the hierarchy levels since you are only showing the matrix values

[stefani_vileva]

The bold ones are the rows, and from the selected one the upper rows are missing. Sorry but I am not able to share the names of the rows and columns..