Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I need to sum values on a column based on multiple conditions on another column in the same table using DAX. For example, here is the table Bicycles:
ID Price Colour
1 10 Green
2 15 Red
3 12 Blue
4 10 Purple
5 12 Yellow
6 15 Magenta
7 12 Red
8 10 Blue
9 12 Teal
I want to summarize the price for all bicycles that are Red, Blue and Green. From the table above it would be 10+15+12+12+10 = 59.
If I want to summarize based on blue this formula works:
Sum of prices for popular colours = CALCULATE(SUM(Bicycles[Price]), FILTER('Bicycles', Bicycles[Colour] = "Blue"))
This also works:
Sum of prices for popular colours = CALCULATE(SUM(Bicycles[Price]), Bicycles[Colour] = "Blue")
However, I need need to add multiple or condions on the colour column to include the colours green and red. I have not been successful. I have tried the following but it does not return anything:
Sum of prices for popular colours = CALCULATE(SUM(Bicycles[Price]), FILTER('Bicycles', Bicycles[Colour] = "Blue"), FILTER('Bicycles', Bicycles[Colour] = "Red"), FILTER('Bicycles', Bicycles[Colour] = "Green"))
Is it possible to put the equivalent of an or condtion to filter on specific values of the same column? How can this be done?
Solved! Go to Solution.
@Lorenz33 try this measure
Sum of prices for popular colours = CALCULATE(SUM(Bicycles[Price]), Bicycles[Colour] in { "Red", "Blue", "Green"})
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.
@Lorenz33 try this measure
Sum of prices for popular colours = CALCULATE(SUM(Bicycles[Price]), Bicycles[Colour] in { "Red", "Blue", "Green"})
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.
I tried this solution for my own dataset but it didn't work. Would that be because my "red/green/blue" field comes from a drop-down list instead of direct entry?
That worked. Thanks.
User | Count |
---|---|
120 | |
72 | |
69 | |
57 | |
50 |
User | Count |
---|---|
167 | |
82 | |
68 | |
65 | |
53 |