Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 |
Solved! Go to Solution.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
108 | |
107 | |
93 | |
69 |
User | Count |
---|---|
169 | |
134 | |
132 | |
95 | |
93 |