Power BI Count rows

 

Using above code, you will get correct recency range filter with correct recency value as below. 

If COUNTROWS is pass in as variable as pre-calculated value, this will result in incorrect result. 

Thus from the observation, you know that DAX programming is not procedural in some of the function.

The COUNTROWS function will iterate through each rows of the table and perform calculation, so it is very important that this function is not use in too big NESTED environment.