'Average per rows

[Anonymous]

Dear Community, 
based on the photo above, I want to add 1 columns for calculating mean value per row(77+78+78.97+79.01+79.50), how can I handle it? 
I tried to do it throught new quick maesure -->  average per category -->  but it does not work it gaves 5 coulmn! I want 1 column for calculating mean of these 5 values.

Thanks in advance

[themistoklis]

@Anonymous 

Try using AVERAGEX

Measure Avg =
IF (
    HASONEVALUE ( 'Table'[Index] ),
    [Measure],
    AVERAGEX ( VALUES('Table'[Index]), [Measure] )
)

[amitchandak · Accepted solution]

@Anonymous , if 1,2,3,4,5 are meausres or column in values 

you can have measure

([1]+[2]+[3]+[4]+[5])/5   // assume all are measures

If the are category values, you need to change Row total

New Measure = Calculate([Average Measure], allexcept(Table, Table[Cluster], Table[Stain], Table[label]))

Use isfilterted or isinscope to change the row total

if(not(isinscope([Category])) , [New Measure ],[Measure])