Forum Discussion
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 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
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
3 Replies
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
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..
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
