Calculated measure not updating in pivot table with date filter

kac8866 — Thu, 27 Feb 2025 01:47:24 GMT

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]))

Re: Calculated measure not updating in pivot table with date filter

AntrikshSharma — Thu, 27 Feb 2025 07:08:06 GMT

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 ) )

topic Re: Calculated measure not updating in pivot table with date filter in DAX Commands and Tips

Calculated measure not updating in pivot table with date filter

Re: Calculated measure not updating in pivot table with date filter