cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ncheaib
Helper I
Helper I

Show summary value if all data in child are available in matrix table

Hello,

 

I have the below table.

I would only like to show the summary value (highlighted in yellow) if all the child level line items (parts) have a value.

For example when collapsed Order 1 has the min of Date 1 and 2 shown because all parts have a value. I don't want it to show the max of "Duration" or "Delta" because not all parts have the data populated in the table (parts e,h,k) for order 1.

 

ncheaib_0-1607119138460.png

My sample data can be found here:
https://drive.google.com/file/d/18zPhPAyLcmNFvU-YK8-BLITiZYwN1jc5/view?usp=sharing

7 REPLIES 7
v-robertq-msft
Community Support
Community Support

Hi, @ncheaib 

According to your description, you want to show summary value if all data in a child are available in the Matrix, I think you can achieve this by changing the data summarize type.

You can click on column [DURATION] and [DELTA], then change the data summarize type to “Sum”, like this:

v-robertq-msft_0-1607417983777.png

 

And I guess this is what you want.

 

If this result is not what you want, you can show more detail of your requirement clearly so that we can help you in advance.

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

PaulDBrown
Super User II
Super User II

@ncheaib 

You can either:

1) Upload a file to a cloud service (OneDrive, Dropbox, Google Drive...) and share the link from there.

2) Copy and paste the table into the "insert table" option (click on the elypsis in the message menu bar to display further options)

table.JPG

 

This link is helpful btw:

How to get your question answered quickly 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






I edited the question and also added a screenshot of powerbi. I added the link to a sample file. 

ncheaib
Helper I
Helper I

below is how the data is structured

ncheaib_0-1607111782300.png

 

@ncheaib 

Sorry but we cannot work on an image. We need actual data!





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






How do I upload the excel file to this thread

PaulDBrown
Super User II
Super User II

@ncheaib 

Can you please provide actual sample data (as opposed to an image)?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.