use of a result of COUNTROWS function inside IF function (incorrect result)

[a_gaisin]

Hello, I'm trying to create a new measure that will take value 1 if number of rows in a specific table is greater than 10, and 0 otherwise. Here's the code that I use: 

GreaterThanTen = IF(COUNTROWS(Table)>10,1,0)

 This measure always returns 0, although there are cases when it's supposed to be 1.

Can you please explain what's wrong?

Thank you.

[Anonymous]

We'd like to see the cases you mention.

Best
D

[nandukrishnavs]

@a_gaisin 

I have replicated your scenario.

GreaterThanTen = IF(COUNTROWS('Table')>10,1,0)

It is working for me

When I apply the filter it is returning zero, which is expected.

In your case, maybe some external filters are there. Verify that.

If you don't want to affect external filters, you can use ALL() or ALLEXCEPT() functions.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂