cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stefani_vileva
Resolver I
Resolver I

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?

Screenshot.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Thanks a lot.

 

Kind regards,

Stefani

 

 

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

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

View solution in original post

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

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
Super User
Super User

@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

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..

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.