Calculate with filters

[Amelia_96]

Hi, can i know how do i calculate this measure in straight table/pivot table but only for certain filter values?

for example, i want to count number of ID, only if the status is equal to 1, and the duration is less than 30 days. other status, i dont want to include in the count. then i want to divide the count with status=1, with overall count.

--> Count(ID where status = 1 & duration < 30) / Count(total ID)

But i dont know how to put it in formula to calculate for expression in table. Please help me.

Thank you so much

[Taoufiq_Zarra · Accepted solution]

@Amelia_96 

like ?

=Count({<status ={'1'},duration={"<30"}>} ID)/Count(total ID)

[Amelia_96]

It works! thank you !!