Average Line, ignore some filters

[NewbieJono]

Hello, i want to add an average line that always shows the overall average of the whole company within the filtered timeline.

However i have another filter on the page that allows to select departments. i can get the average to work for this. and i wish to keep this but i want to compare to an average of the whole company.

what dax do i need to show average for all depatments, i need to ignore all filters apart from the date

here is the chart, which dynamically changes when department changes

[NewbieJono]

my total staff is a measure (count of a staff ID), how can I include this in the table value, instead of AVERAGE(Table[Value])

[Anonymous]

In my opinion it is best practice to create a new measure for that kind of thing.

Overall Average =
VAR TotalStaffCount = [Total Staff]
RETURN CALCULATE(TotalStaffCount, ALL(Table[Department]))

If this helped please mark as solved!

Thanks 

-DD

[NewbieJono]

does this calc the average? also will it ignore the filters on the page relating to department

[Anonymous]

Hey Jono,

I think you would need to create a new measure for all departments, somthing like:

Overall Average = CALCULATE(AVERAGE(Table[Value]), ALL(Table[Department]))