Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Applying Two Date Filters to KPI for Count

I'm trying to get the count of members with two date filters applied. Currently I have a date table that has a relationship with the merge table I'm working on that is connected to "open date" of cer...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi Anonymous ,

Sorry I'm not quite clear the below points:

1. "I need to apply another filter that looks at that same date range as the global for an open date." which column do you want to use in the "another filter".

2. In my sample, the measure New Member Checking Count PM get same result with measure KPI Needed.

 

I create a sample to reprodeuce your problem, I attach it below, please explain more about your purpose with the sample I provided.

 

Best regards,

Community Support Team_yanjiang

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, 

     

    Thank you for the file. Hopefully this adds clarity. The column I want to apply as the "other filter" is 

    Merge1[OPENDATE]. So for example I have a COUNT(Merge1[V_SAVINGS.PARENTACCOUNT]) that is filtered by the V_SAVINGS.OPENDATE (global filter), which is also filtered by Merge1[OPENDATE] of the same date range. Because there are some members who have a checking account opened who are also new members -- that's what the two dates are looking for.