Average not calculating on line graph

Hi Amy,

Thank you for the forum question.

It is always challenging to answer DAX question because a lot is depending on the data model, row context, filter context, and table context.

I have tried different logic and the below may be the solution for you.

Average total activity =
var SumofTotalActivity = calculate(sum('IP&OP SUS'[RecordCount]), Filter('Dim_SUS Forecast Dates',[Year]<>2020))

var NumberofDataPoints = calculate(DISTINCTCOUNT('IP&OP SUS'[DateConcatenated - Date]), Filter('Dim_SUS Forecast Dates',[Year]<>2020))

Return

calculate(Divide(SumofTotalActivity,NumberofDataPoints))



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector