DAX for filtering data by both dates and primary key

Green_Cloud — Mon, 23 May 2022 01:05:12 GMT

Hello,

I would like to see the INQUIRY COUNT and APPLICATION COUNT in a table which will be organized by weeks and also the APPLICATION COUNT will be the subset of INQUIRY COUNT (same people who inquired and applied). The primary key in INQUIRY table is INQUIRY_EMAILID field which stays as foreign key in Application table by APPLICATION_EMAILID.

the formula for INQUIRY COUNT and APPLICATION COUNT is as follows:

INQUIRY COUNT=COUNT(INQUIRY_INQUIRYDATE)

APPLICATION COUNT=COUNT(APPLICATION_APPLYDATE)

Here's a snapshot of current data model which limits data by email id irrespective of same week for both inquiry and application date. I need to see how many people who inquired on a certain week comes back in the same week for application (people who applied need to be the subset of people who inquired as well)

A sample expected output format is as follows:

Re: DAX for filtering data by both dates and primary key

tamerj1 — Wed, 18 May 2022 06:01:53 GMT

Hi Green_Cloud
What is the smaple input data for this sample expected output?

Re: DAX for filtering data by both dates and primary key

Green_Cloud — Mon, 23 May 2022 01:06:15 GMT

Hello tamerj1 , it's no longer needed as the requirement has changed. Appreciate your response!

topic Re: DAX for filtering data by both dates and primary key in DAX Commands and Tips

DAX for filtering data by both dates and primary key

Re: DAX for filtering data by both dates and primary key

Re: DAX for filtering data by both dates and primary key