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:
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.
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.
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:
Check out new user group experience and if you are a leader please create your group
Click here to read more about the April 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.