Calculating Average Sales

Hello Experts

I am trying to calculte the Average Sales and using a slicker to filter the month and supplier, but its calculating the average incorrectly

The DAX i am using is below

Average v3 = AVERAGEX(ALLEXCEPT(Calendar,Calendar[Date] ), [Total Sales Value])

I have searched this forum for help and can't seem to find anything that will calculate it correctly

The average should be

37210.46+10798.88 = 48009.34/2 = 24004.67

The result I am getting is incorrect

What am I doing

write like this:

Average v3= DIVIDE([Total Sales Value],DISTINCTCOUNT('Table'[Category]))

Forum Discussion