Calculated measure not updating in pivot table with date filter

[kac8866]

I have data that has sales for servers within different categories (Apps, Desserts, etc). The rows are summed by individual menu items. Below is a screen shot of part of the table

 The date column is the last day of the fiscal week. There is a separate Date Table and the proper relationship is active between the two tables.I have a measure that calculates the sales of each server by category. But when I put that measure into a pivot table with Fiscal week as a filter, I only get the total for all three fiscals weeks no matter what week, or combination of weeks, I select in the fiscal week filter. Not sure how to have this measure change with the date filter. The measure is 

ServerCategorySales = CALCULATE(SUM(LEX_Data[Sales ($)]), ALLEXCEPT(LEX_Data,LEX_Data[Category],LEX_Data[Team Member]))

[AntrikshSharma · Accepted solution]

@kac8866 Functions like ALL, ALLEXCEPT, REMOVEFILTERS etc removes the Filters from the Expanded Tables, if LEX_Data is on the Many side then any table that is on the One side will also be impacted.

In ALLEXCEPT you need to include those Date columns that should be allowed to Filter the calculation, you can keep some columns or whole Dates table.

ServerCategorySales =
CALCULATE (
    SUM ( LEX_Data[Sales ($)] ),
    ALLEXCEPT (
        LEX_Data,
        LEX_Data[Category],
        LEX_Data[Team Member],
        Dates[Column],
        Dates
    )
)