Number of Rows

[Anonymous]

Order_ID	Amount	Status
1	750	Won
2	345	Open
3	556	Won
4	7777	Open
5	8900	Lost
6	123	Lost
7	432	cancelled
8	543	open
9	12323	open
10	7657	open
11	6545	Open
12	54534	Won

I would like to calculate the number of rows where the status is differnt than Won, Cancelled or Lost

Measure = COUNTROWS(FILTER(Orders ,Orders[Status]<>"Won" || Orders[Status]<>"Lost" || Orders[Status]<>"Cancelled"))

but it

[amitchandak]

@Anonymous , use in and revert it with NOT

Measure = COUNTROWS(FILTER(Orders ,not(Orders[Status] in {"Won" , "Lost","Cancelled"})))

[Ashish_Mathur]

Hi,

Replace || with &&

[Anonymous]

What I need is any of the status not all of them so it's OR and not and

[Ashish_Mathur · Accepted solution]

Hi,

With my suggestion, the answer will be 6 (Open cases).  Please try it.

[Anonymous]

You are so great it's working

thanks

[Ashish_Mathur]

You are welcome.