Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Number of Rows

 

Order_IDAmountStatus
1750Won
2345Open
3556Won
47777Open
58900Lost
6123Lost
7432cancelled
8543open
912323open
107657open
116545Open
1254534Won

 

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

 

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

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

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        6 years ago

        Hi,

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

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , use in and revert it with NOT

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