Filtering Crossfilter Measure

[Unknowncharacte]

Hi, 

I used @amitchandak YouTube video  to calculate this Active Case count.

Now, I need to create a new measure off of this one, and filter only those cases that were opened for => 90 days.

So, I will have an "Active Cases Count of Cases that were open for more than 90 days" measure.

Can someone please help me adjust this measure to get only cases that were open for => 90 days?

I will then use this measure to divide by Active Cases Count to get a % 

Active Case Count =
CALCULATE
(COUNTx(FILTER('Fact Table', 'Fact Table'[DateOpened]<=max('DIM Calendar'[Full Date])
&& (ISBLANK('Fact Table'[DateClosed])
|| 'Fact Table'[DateClosed]>max('DIM Calendar'[Full Date]))), ('Fact Table'[CaseNumber])),
CROSSFILTER('Fact Table'[DateOpened],'DIM Calendar'[Full Date],None))

Sample of my data:

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but try something like below if it works.

Active Case Open for 90 days Count =
CALCULATE (
    COUNTX (
        FILTER (
            'Fact Table',
            'Fact Table'[DateOpened] <= MAX ( 'DIM Calendar'[Full Date] )
                && NOT ISBLANK ( 'Fact Table'[DateClosed] )
                    && 'Fact Table'[DateClosed] > MIN ( 'DIM Calendar'[Full Date] )
                    && 'Fact Table'[DateClosed] - 'Fact Table'[DateOpened] >= 90
        ),
        ( 'Fact Table'[CaseNumber] )
    ),
    CROSSFILTER ( 'Fact Table'[DateOpened], 'DIM Calendar'[Full Date], NONE )
)

[Unknowncharacte]

Thank you so much!