Count with logical test in Power Pivot

[mozhiarasu]

Hi Everyone,

I have a table with a list of Revenue, I want to count the number of orders, which are more than $100, what is the function I need to use..???

I'm new to power pivot. in excel we use COUNTIF, here I'm not use

thanks in advance

Cheers

MS

 

[severynm]

Welcome!

Working with measures and DAX is a bit different, give this a try (substituting TableName for the name of your table):

=CALCULATE(COUNT(TableName[revenue]),FILTER(TableName,[revenue]>100))