How to count rows with conditions from measure

[chanon]

I have a measure DoH derived from creation of Measure ( DoH = Stock / Avg. Usage) 

and I want to count Product name at DoH< 10 = ? and  DoH > 100 = ?  

From example  - DoH < 10 = 3

                         - DoH > 100 = 1 

[v-henryk-mstf]

Hi @chanon ,

Whether the advice given by @PaulDBrown  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Looking forward to your feedback.

Best Regards,
Henry

[PaulDBrown]

Try:

Less than 10 = 
CALCULATE(COUNT(Table[Product[), FILTER(Table, [DoH] <10))

More than 100 = 
CALCULATE(COUNT(Table[Product[), FILTER(Table, [DoH] >100))

[chanon]

Thk for reply but didn't work. Due to DoH is Measure when i create count measure then result is 7. 

[PaulDBrown · Accepted solution]

This is what I'm getting:

DoH = 
DIVIDE(SUM('Table'[Stock]), SUM('Table'[Avg. Usage]))

Less than 10 =
CALCULATE ( COUNT ( 'Table'[Product name] ), FILTER ( 'Table', [DoH] < 10 ) )

More than 100 =
CALCULATE ( COUNT ( 'Table'[Product name] ), FILTER ( 'Table', [DoH] > 100 ) )

[Arul]

@chanon ,

please try this,

1. DoH < 10,

count of product DoH < 10 = CALCULATE(COUNT('Table'[Product name]),FILTER('Table',[DOH]<10))

2.DoH >100,

count of product DoH > 100 = CALCULATE(COUNT('Table'[Product name]),FILTER('Table',[DOH]>100))

Thanks,

Arul