Forum Discussion
Post PatronSumming with multiple filters
I am trying to create a measure that calculates the Sum of all spend for “Type” (A) where “Transpo” equals(car, boat, truck , bike) while excluding Accounts 9,10,11. Can anyone help me with this?
| type | Spend | Account | Transpo |
| A | 20,000,000 | 1 | car |
| A | 20,000,000 | 2 | Boat |
| A | 20,000,000 | 3 | Truck |
| A | 20,000,000 | 4 | Bike |
| A | 20,000,000 | 5 | Plane |
| A | 50,000,000 | 6 | Helicopter |
| A | 10,000,000 | 7 | Truck |
| A | 10,000,000 | 8 | Bike |
| A | 50,000,000 | 9 | Plane |
| A | 50,000,000 | 10 | Helicopter |
| A | 50,000,000 | 11 | Scooter |
| B | 10,000,000 | 3 | board |
| B | 10,000,000 | 3 | skate |
dw700d try this
Measure = CALCULATE ( SUM ( Table[Spend] ), Table[Type] = "A", Table[Transpo] IN {"car", "boat", "truck" , "bike"}, NOT Table[Account] IN {9,10,11} )Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
3 Replies
- parry2k
Super User
dw700d try this measure
Measure = CALCULATE ( SUM ( Table[Spend] ), Table[Transpo] IN {"car", "boat", "truck" , "bike"}, NOT Table[Account] IN {9,10,11} )Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- parry2k
dw700d try this
Measure = CALCULATE ( SUM ( Table[Spend] ), Table[Type] = "A", Table[Transpo] IN {"car", "boat", "truck" , "bike"}, NOT Table[Account] IN {9,10,11} )Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
