Forum Discussion

ThaddeusB's avatar
ThaddeusB
Helper I
7 years ago
Solved

Filter for active within time range

I have a set of data like (plus additional columns:   Client Entry Date Exit Date 205 3/24/2018 3/26/2018 206 12/9/2009 7/26/2017 207 11/10/2017 12/21/2017 208 10/29/2017 1...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    ThaddeusB

     

    try something on these lines

    See file attached as well

     

    Then you can use the MEASURE as a visual filter

     

    Measure =
COUNTROWS (
    FILTER (
        table1,
        Table1[Entry Date] >= MIN ( 'Calendar'[Date] )
            && Table1[Exit Date] <= MAX ( 'Calendar'[Date] )
    )
)

     

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

The result should also include 205 and 210.  You may download my PBI file from here.

 

Hope this helps.

 

ThaddeusB's avatar
ThaddeusB
Helper I
7 years ago

Thank you both.  I had set up the filter very similarly, but was not getting the expected results.  My problem was that I was putting the measure ONLY in the visual filters of a pie chart and using count(client) for the values.  Putting count(measure) in the values section instead of count(client) fixed it.