Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

'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 -...
Need Help
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

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

amitchandak's avatar
amitchandak
Super User
5 years ago

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