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

[ncheaib]

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.

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

[v-robertq-msft]

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:

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]

@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)

This link is helpful btw:

How to get your question answered quickly 

[ncheaib]

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

[ncheaib]

below is how the data is structured

[PaulDBrown]

@ncheaib 

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

[ncheaib]

How do I upload the excel file to this thread

[PaulDBrown]

@ncheaib 

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