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 --> 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
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])
2 Replies
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] ) )
