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 certain accounts. I have a global filter on the dashboard of that, so that count of members will adjust. However I want to additionally account for members who are entirely new -- so I need to apply another filter that looks at that same date range as the global for an open date. I tried doing a calculated measure that took into account the second date filter

 

Global Filter/Slicer = V_SAVINGS.OPENDATE (<-- this is connected to the date table)

KPI Needed = COUNT(Merge1[V_SAVINGS.PARENTACCOUNT])

 

New Member Checking Count PM = CALCULATE(COUNT(Merge1[V_SAVINGS.PARENTACCOUNT]),FILTER(Merge1, Merge1[OPENDATE]))
Need Help

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity 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.