Count TRUEs in filtered expression

[Diego-mx]

This is a simple idea, but I can't figure out how to do it.  
I only need three columns in a table:   

object_id (int key), 
event_month (date), 
event_condition (logical)

Even if condition is FALSE, there may be a date.  

I just want to get the maximum count of conditioned objects based on date.  

Monthly_Max = MAXX( 
    KEEPFILTERS(VALUES([event_month])), 
    COUNTX(FILTER('Table', [event_condition] = TRUE()), 
        [object_id]))
)

But the second filter, doesn't respect the first filter.  
And I have tried other ways with CALCULATE with no success.  

I feel like this is gonna be easy, but I still need to get my head around it.  
Thanks 

[v-qiuyu-msft · Accepted solution]

Hi @Diego-mx,

You can create a measure below:

CountTrue = CALCULATE(COUNT(Table1[object_id]),FILTER(ALL('Table1'),'Table1'[event_condition]=TRUE()))

Best Regards,
Qiuyun Yu