Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi,
With my suggestion, the answer will be 6 (Open cases). Please try it.
@Anonymous , use in and revert it with NOT
Measure = COUNTROWS(FILTER(Orders ,not(Orders[Status] in {"Won" , "Lost","Cancelled"})))
Hi,
Replace || with &&
What I need is any of the status not all of them so it's OR and not and
Hi,
With my suggestion, the answer will be 6 (Open cases). Please try it.
You are so great it's working
thanks
You are welcome.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |