Multi filters

[BORUCH]

HI
I HAVE THIS FORMULA

Sales Flag:=IF(NOT(ISEMPTY(CALCULATETABLE('sales','sales'[Qty Ord] >0))),"Had Sales","Had No Sales")

Two questions

#1
how can i have this formula also do a filter for [qty ord] is less the ZERO
I want it to tell me only if its less then zero or greater the zero not equal zero

#2
HOW CAN I HAVE THIS AS A SLICER (FILTER)
HAD SALES
HAD NO SALES

 

[BORUCH]

OK so is it possible to use a measure as a slicer whatever the formula maybe
as a general question ?

 

[Matt Allington]

No, it is not possible to put a measure as a slicer. You could however create a disconnected table and use that. You can read about the general technique at my blog here Measures on Rows - Here is How I did it - Excelerator BI