Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Count orders that does not include x (Filter granularity)

Hi,   I have a sales tables, with 1 line for every item in an order.   My goal is to count the amount of orders that has a revenue below 319,2 and were the order does not include an item from the...
Need Help
dedelman_clng's avatar
dedelman_clng
Community Champion
9 years ago

When you're in CALCULATE, everything *after* the value to be calculated (in your case COUNTROWS(VALUES(Sale[OrderID])) ) contains an implicit FILTER.  So you should be able to just put the conditions you are looking for in the CALCULATE statement:

 

Orders below 319,2, NON-FOOD = 
CALCULATE(
	COUNTROWS(VALUES(Sale[OrderID]));
	  Sale[Sales Revenue] < 319,2;
	  Product[MainGroup] <> "FOOD"
)

Hope this helps

 

David