Forum Discussion

alops's avatar
alops
Frequent Visitor
3 years ago

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

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.

Need Help

4 Replies

  • rajulshah's avatar
    rajulshah
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    alops 

     

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

    • alops's avatar
      alops
      Frequent Visitor
      3 years ago

      no so I calculate the maximum per line.

       

      • rajulshah's avatar
        rajulshah
        Icon for Resident Rockstar rankResident Rockstar
        3 years ago

        alops ,

         

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