sum of average per category

[Chrisjr]

Hi All, 

I have the following table: 

(the column "avg per waves" is a dax formula)

Dealer/Group Name	KPI	Waves	Score	avg per waves
Delbarti	Structure	Wave 1	9	15.75
Delbarti	Structure	Wave 2	18	15.75
Delbarti	Structure	Wave 3	12	15.75
Delbarti	Structure	Wave 4	24	15.75
SA NV	Structure	Wave 1	5	9.75
SA NV	Structure	Wave 2	9	9.75
SA NV	Structure	Wave 3	11	9.75
SA NV	Structure	Wave 4	14	9.75
Delbarti	Welcome	Wave 1	23	17.75
Delbarti	Welcome	Wave 2	21	17.75
Delbarti	Welcome	Wave 3	20	17.75
Delbarti	Welcome	Wave 4	7	17.75
SA NV	Welcome	Wave 1	11	14.25
SA NV	Welcome	Wave 2	12	14.25
SA NV	Welcome	Wave 3	24	14.25
SA NV	Welcome	Wave 4	10	14.25

I need to calculate the sum of the average score per 4 waves.

1. I first need to get the average value of the 4 waves together.  So in the image above, I would get an average value of 15,75 for the first green block.

2. then I need the sum of the average of the 4 waves. So I would need the sum of 15,75 + 9,75 + 17,75 + 14,25.

How could I achieve that knowing this mesure should be used in different visuals. 

Below is my data model:

Thanks for the help

[Chrisjr]

@FreemanZ thanks a lot for your help 

[FreemanZ · Accepted solution]

hi @Chrisjr ,

not sure if i fully get you, try to plot a measure like:

Measure = 
VAR _table = 
ADDCOLUMNS(
    SUMMARIZE(
        data,
        Dim_Dealers[dealer/group name],
        Dim_KPI[kpi]
    ),
    "ScoreAvg",
    CALCULATE(AVERAGE(data[Score]))
)
VAR _result = SUMX(_table, [ScoreAvg])
RETURN _result

it worked like: