Forum Discussion
Summarization
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
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..