Forum Discussion
Diego-mx
Advocate I
Advocate ICount TRUEs in filtered expression
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 FAL...
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
v-qiuyu-msft
Community Support
Community SupportHi 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