average instead of sum

[Giada90]

Hi,

I have a database like this:

a	b	c	d	e
sara	1	2	6	7
chiara	5	6	7	6
ambra	8	3	2	3

I have this measure: 

Measure = sum(Foglio1[b])+ sum(Foglio1[c])+ sum(Foglio1[d]) + sum(Foglio1[e])

I have a table and a gauge like this:  

I need to have the average of measure (18,6) instead of sum in both gauge and total in the table

How can I do?

Thanks

[johnt75 · Accepted solution]

Try

My measure =
IF (
    ISINSCOPE ( 'Foglio1'[a] ),
    SUMX ( 'Foglio1', 'Foglio1'[b] + 'Foglio1'[c] + 'Foglio1'[d] + 'Foglio1'[e] ),
    AVERAGEX (
        'Foglio1',
        'Foglio1'[b] + 'Foglio1'[c] + 'Foglio1'[d] + 'Foglio1'[e]
    )
)

[Giada90]

thanks!