Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

DAX for filtering data by both dates and primary key



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:





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:




Super User
Super User

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

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

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors