Forum Discussion
Calculate average on data that are summarized
I have a table with case event data How do I calculate the average where the durations are first summarised per case, and then divided by total number of cases. When I try now I'm only g...
Anonymous , Try measures like
Averagex(values(Table[Casenumber]), calculate(sum(Table[Duration In Min])) )
or
Averagex(summarize(Table, Table[Casenumber],"_1", calculate(sum(Table[Duration In Min])) ),[_1])