Generic date

you didnt get my point of view
what i need to see the last date of the offer and count it in this date
The DAX measure Under Investigation counts the number of customers whose SUBMISSION_TO_RISK date is blank (meaning they are under investigation)

Under Investigation = CALCULATE(COUNT('Table'[CUSTOMER_NAME]),FILTER(ALL('Table'),[OFFERS_DATE]>=MIN('Date'[Date])&&[OFFERS_DATE]<=MAX('Date'[Date])&&[SUBMISSION_TO_RISK]=BLANK()))

 Summary

• Total Offers: 5
• Under Investigation: 1 (Client 11)

Submission to Risk Phase

• Clients whose offers ended in this phase:
  • Client 32
  • Client 44

Submission to Credit Phase

• Clients whose offers ended in this phase:
  • Client 85

Approval Phase

• Clients whose offers ended in this phase:
  • Client 49
    So based above info  when iam chossing this period give me this result
    did you get my point ?