Forum Discussion
'Average per rows
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 -...
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])
Anonymous
Try using AVERAGEX
Measure Avg =
IF (
HASONEVALUE ( 'Table'[Index] ),
[Measure],
AVERAGEX ( VALUES('Table'[Index]), [Measure] )
)