Forum Discussion

Romani's avatar
Romani
Helper II
2 years ago

Generic date

  CUSTOMER_NAME Offer Id OFFERS_DATE OFFER_ACCEPTANCE_DATE REJECTION_DATE INVESTIGATION_DATE SUBMISSION_TO_RISK SUBMISSION_DATE_TO_CREDIT APPROVAL_DATE Client 2 1 13/02/2023      ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
Romani
Helper II
2 years ago

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 ?
  • Romani's avatar
    Romani
    Helper II
    2 years ago

    Anonymous ???