Generic date

BeaBF 

Hi, Romani 

You can try the following methods.

Measure:

Total Offers = CALCULATE(COUNT('Table'[CUSTOMER_NAME]),FILTER(ALL('Table'),[OFFERS_DATE]>=MIN('Date'[Date])&&[OFFERS_DATE]<=MAX('Date'[Date])))

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

Measure = IF(SELECTEDVALUE('Table'[OFFERS_DATE])>=MIN('Date'[Date])&&SELECTEDVALUE('Table'[OFFERS_DATE])<=MAX('Date'[Date]),1,0)

I can do this part. For other desired outcomes, you need to elaborate on the logic.

Best Regards,

Community Support Team _Charlotte

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

Romani second step:

Total Offers = COUNTROWS('Table')

Under Investigation =
CALCULATE(
COUNTROWS('Table'),
'Table'[OfferStatus] = "Under Investigation"
)

Clients Submission to Risk =
CALCULATE(
COUNTROWS('Table'),
'Table'[SUBMISSION_TO_RISK] <> BLANK(),
'Table'[SUBMISSION_DATE_TO_CREDIT] = BLANK(),
'Table'[APPROVAL_DATE] = BLANK(),
'Table'[REJECTION_DATE] = BLANK(),
'Table'[INVESTIGATION_DATE] = BLANK()
)

Clients Submission to Credit =
CALCULATE(
COUNTROWS('Table'),
'Table'[SUBMISSION_DATE_TO_CREDIT] <> BLANK(),
'Table'[APPROVAL_DATE] = BLANK(),
'Table'[REJECTION_DATE] = BLANK(),
'Table'[INVESTIGATION_DATE] = BLANK()
)

Clients Approval =
CALCULATE(
COUNTROWS('Table'),
'Table'[APPROVAL_DATE] <> BLANK()
)

If you want Client name:
Client Names Under Investigation =
CONCATENATEX(
FILTER(
'Table',
'Table'[OfferStatus] = "Under Investigation"
),
'Table'[CUSTOMER_NAME],
", "
)

Client Names Submission to Risk =
CONCATENATEX(
FILTER(
'Table',
'Table'[SUBMISSION_TO_RISK] <> BLANK() &&
'Table'[SUBMISSION_DATE_TO_CREDIT] = BLANK() &&
'Table'[APPROVAL_DATE] = BLANK() &&
'Table'[REJECTION_DATE] = BLANK() &&
'Table'[INVESTIGATION_DATE] = BLANK()
),
'Table'[CUSTOMER_NAME],
", "
)

Client Names Submission to Credit =
CONCATENATEX(
FILTER(
'Table',
'Table'[SUBMISSION_DATE_TO_CREDIT] <> BLANK() &&
'Table'[APPROVAL_DATE] = BLANK() &&
'Table'[REJECTION_DATE] = BLANK() &&
'Table'[INVESTIGATION_DATE] = BLANK()
),
'Table'[CUSTOMER_NAME],
", "
)

Client Names Approval =
CONCATENATEX(
FILTER(
'Table',
'Table'[APPROVAL_DATE] <> BLANK()
),
'Table'[CUSTOMER_NAME],
", "
)

BBF