Sum of a measure by month and by cathegory

[KaiFrehner]

Hello All, 

I am new to Power Bi and have a specific requirement, that I have been trying to figure out for a while. I appreciate the help!

Data:  looks as follows.

- posting date: when the Tasks have been completed and reported. 
- Dauer: duration of the task (production of items)

- Output_quantity: amount of items created.

- Gruppierung: several products (item_number) belong to a group. There are three different Groups. 

Visual: 

I can get the average time for one item Dauer/Output_quantity with the measure 2: 

I would now like to get the sum of the averages per cathegory per month. see the red squares. 
Ideally i would get the following values. 

[KaiFrehner]

perfect - Thank you!

[v-rzhou-msft · Accepted solution]

Hi @KaiFrehner ,

Here I suggest you to create a new measure based on [Measure 2].

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

Best Regards,
Rico Zhou

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