### Why does this calculate work (and others don't)?

Posted:

**Wed Apr 22, 2020 11:00 pm**I have a small question during the excercises in the book. I cannot figure out why if you use

Customers with Sales Greater Than 5000 = CALCULATE(COUNTROWS(FILTER(Customers;[Total Sales]>=5000)))

is is working well while you put countries on rows and it is not working for

Total Number of Customers = (countrows(Customers))

I understand that you filter customers based on a total sales filter. However, I don't understand why the first formula works while filtering on product category (on rows). In my opinion you if try to filter upstream (from customers to sales to products) it does not work.

Customers with Sales Greater Than 5000 = CALCULATE(COUNTROWS(FILTER(Customers;[Total Sales]>=5000)))

is is working well while you put countries on rows and it is not working for

Total Number of Customers = (countrows(Customers))

I understand that you filter customers based on a total sales filter. However, I don't understand why the first formula works while filtering on product category (on rows). In my opinion you if try to filter upstream (from customers to sales to products) it does not work.