how to calculate max value which changes based on date filter?

[alops]

Hi, I need your help.
i managed to calculate the maximum for the group of the same id with a computed column.

Colonna 2 =

CALCULATE ( MAX ( terna_auditopportunities [terna_statosuccessivo] ), ALLEXCEPT ( terna_auditopportunities , terna_auditopportunities [opportunityid] ))

now i want the max to change if i change the date filters. for example I want that if I go to the date 10/17/2022 the maximum is no longer 293360003 but 293360001. how can I do ??
thanks a lot experts.

[lucadelicio]

can you share the pbix?

[rajulshah]

@alops 

Try using ALLSELECTED instead of ALLEXCEPT. Please let me know if that didn't work.

[alops]

no so I calculate the maximum per line.

[rajulshah]

@alops ,

Can you please share the sample data and the output with it? Would be helpful.