Conditional Sum in Matrix

[KaiFrehner]

Hello All, 

I have a some what complex use case that I need help with. 

we have reporting of how many pieces are produced in how much time. I already received help from @Anonymous to obtain the average per piece and month with the measures: 

Measure 2 =
CALCULATE(
    Divide( SUM([Dauer]), SUM([Output_Quantity]))
)

NewMeasure with Correct Subtotal = 
SUMX (
    SUMMARIZE ( 'Kapazitätsposten', 'Kapazitätsposten'[Gruppierung], 'Kapazitätsposten'[Item_No] ),
    [Measure 2]
)

This gives me the following Matrix Visual: 

I would now like to sum these values per month into the following two Products: Product MDC 22 and Product MDC 44 (theser are different to the ones already used in the Matrix Visual). These Cathegories should be comprised as follows:
Product MDC22: all of Baugruppe Allgemein + All of MDC 22
Product MDC44:  105546 + 2x 101701 + 2x 101690 + 105572 + all of MDC44
When the Matrix is blank, an average of that piece over the whole year should be used for the summation. 
This should give me an overview of the average build time per Unit per month. 
Thank you very much in advance for your help and all the best!
-Kai

[KaiFrehner]

Hello @v-yueyunzh-msft 
Sorry for the delay in my response - I was on holiday. 
You have understood the requirements percisely. 
Here is the PBIX File PBI_Produktions - PBI Community.pbix
Thank you so much for your help!
Best regards, Kai Frehner

[v-yueyunzh-msft]

Ηi , @KaiFrehner 

Based on your requirements description, I can roughly understand your needs, and you want to implement these monthly values into two products: product MDC 22 and product MDC 44, when the matrix is blank, the average of the whole year should be summed using this part, but without any data model and sample data, I can't fully understand what you mean and translate it into practice, If convenient, can you provide some sample data or sample .pbix files that do not contain sensitive data?

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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