Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
All
Extremely new to power bi. I am looking to create a new table from an existing table. But I want to exclude any lines with the values "in Production", "Shipped" and "Delivered" in the order status column. I have tried to use summarize but it is not working for me. Any help would be appreciated.
Order | Customer | Order Status |
1 | Fred's autobody | In Production |
2 | Fred's autobody | Back-ordered |
3 | Fred's autobody | Packing |
4 | Fred's autobody | New |
5 | Fred's autobody | Back-ordered |
6 | Fred's autobody | New |
7 | Fred's autobody | Shipped |
8 | Fred's autobody | Delivered |
9 | Fred's autobody | In Production |
10 | Fred's autobody | Short Material |
filter(Table, not(table[Order Status] in {"In Production","Shipped","Delivered"}))
Or
calculatetable(Table,filter(Table, not(table[Order Status] in {"In Production","Shipped","Delivered"})))
Hi @tjeffries,
You can do this using the Summarize, the code below should work;
New Table = FILTER(
SUMMARIZE('Table','Table'[Order],
"customer", MAX('Table'[Customer]),
"Order Status", MAX('Table'[Order Status])
)
, [Order Status] <> "In Production" && [Order Status] <> "Shipped" && [Order Status] <> "Delivered")
I would question as to weather you need to use this? could you not dupicate the table and add visual level filters? or even duplicate it Query and apply the filters at query level?
If you need some advice let me know
Dobby
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |