Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

Please have a try.

Create a measure.

Measure = var case_1 = SUMX(ALL('Table'),'Table'[Duration])
var number = CALCULATE(DISTINCTCOUNT('Table'[CaseNumber]),ALL('Table'))
var result = DIVIDE(case_1,number)
return result

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.