Allexpect not working with date range change

Thanks for the reply from parry2k, please allow me to provide another insight.

Hi Abhishekkl ,

Below is a data table created based on the information you provided.

Use the following measure to calculate the maximum value for a particular group.

Max value =
CALCULATE (
    MAX ( 'Table'[value] ),
    ALLEXCEPT ( 'Table', 'Table'[Group], 'Table'[Date] ),
    ALLSELECTED ( 'Table'[Date] )
)

ALLEXCEPT ( 'Table', 'Table'[Group], 'Table'[Date] ) :

• Remove filters from the table except for the 'Group' and 'Date' fields.

ALLSELECTED ( 'Table'[Date] )

• Removes the filters from the 'Date' field in the visual. Keep filters from external 'Date' field, such as slicers created by 'Date' field.

The final result is shown below.

When the range of the external 'Date' field changes, the measure will change with it.
But it will not be filtered by the 'Date' field that is in the same visual.

Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.