Measure not updating with date slicer selection

[walkery]

I have a measure in my table that is calculating the average deal value per office by summing the gross dollar amount by office divided by the total number of deals per office. The calculation is working well and is correct. However, I also have a date slicer on my report and when the dates are toggled the measure is not updating at all and therefore the bar chart is static. Is there a better way to accomplish my goal?

Measure = CALCULATE(SUM(rvw_USAOOfficeReferrals[GrossCommissionUSD]),ALLEXCEPT(rvw_USAOOfficeReferrals,rvw_USAOOfficeReferrals[OTerritory])) / CALCULATE(SUM(rvw_USAOOfficeReferrals[Count]),ALLEXCEPT(rvw_USAOOfficeReferrals, rvw_USAOOfficeReferrals[OTerritory]))

[Anonymous · Accepted solution]

Hi @walkery,

Add your DateColumn in rvw_USAOOfficeReferrals to the ALLEXCEPT function in your DAX formula.
ALLEXCEPT removes all context filters in the table except filters that have been applied to the specified columns, so it can not filter by Dates if this column is not specified in the function.

Regards.

[walkery]

@Anonymousthank you so much! that worked!