How to Specify Multiple Filter Conditions in CALCULATE [Power BI]

[@bzflowerbee]

Simple and easy to understand as always! Appreciate it!

[@NestorAdrianzen]

Thanks for your feedback, Bzflowerbee. Keep it up! 👊

[@davidbourgeois3981]

Thank you! One of the rare times that I actually saw what I needed within the first few minutes. Appreciate it!

[@NestorAdrianzen]

David, Thanks for your feedback and keep up the great work!👍

[@sophyrath9299]

Love you! you are the best! easy to understand.

[@NestorAdrianzen]

Glad it was helpful, Sophy Rath. Keep up the great work👍

[@michafabich9213]

really appreciate your tutorials, amazing stuff

[@NestorAdrianzen]

Thanks for your support, Michal!

[@pavelsantiago1308]

You Are the best bro!

[@NestorAdrianzen]

Excellent! Keep it 🆙, Pavel.

[@IvanCortinas_ES]

Supreme video. Thumbs up!!!! Thank you Nestor.

[@NestorAdrianzen]

Excellent! Glad this video was helpful.

[@nataliaberra5628]

Thank you! you saved my day!

[@NestorAdrianzen]

Glad you found it helpful, Natalia. Keep it 🆙

[@erdalyayvan654]

Another great video! Keep up the good work👍

[@NestorAdrianzen]

Glad to hear that! Keep it up, Erdal! 👊

[@ahshineyaca]

Hi Nestor, how to breakdown the filter into different sections? I saw you put two filters at the same time and then comma. What about I need to filter multiple products? Say more than 5 products at a time, what shall I do?

[@NestorAdrianzen]

You will want to use IN {“product1”, “product2”}

[@ahshineyaca]

Thank you!

[@miller1520]

You're a great help, thanks!!

[@NestorAdrianzen]

Excellent! Keep it 🆙 👍

[@DiCh-jp8ms]

How can i filter empty cells combined with sales with specific status in other column? I want to use a measure that calculates total sales and to filter it once by all empty cells in column 1 and then all sells that say discount in the discount column.

[@NestorAdrianzen]

If you want to add values which column is empty, you can use the BLANK() function as a filter argument of CALCULATE. See below. I hope that helps! Sales for Blank Items := CALCULATE( SUM(Table[SalesColumn]), Table[AnotherColumn] = BLANK() )

[@barneybear3937]

Hi, i have followed along to the letter and for the profit germany government KEEPFILTERS just get "The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression."??

[@NestorAdrianzen]

Barneybear, Thanks for checking the content! Make sure that the KEEPFILTERS function covers the whole expression with parenthesis. I hope this helps!

[@jyotidatta2126]

Hi Nestor, how can I use '&&', if I have to mention multiple values for one particular column? Like if I have to pass multiple values for same column in one filter condition, how can I do it (instead of 'OR' ||)

[@NestorAdrianzen]

If you are planning on adding multiple options within the same column, you will want to use the IN operator. For example, see below a measure. Three Products := CALCULATE( SUM(financials[Profit]), financials[Product] IN {"Amarilla", "Paseo", "Carretera"} )

[@sravankumar1767]

Nice explanation 👌

[@NestorAdrianzen]

Glad you found it helpful. Keep it up, Sravan Kumar!

[@rahman3344]

Love you much more for your knowledge and yours Boom 💥💥💥💥 also

[@NestorAdrianzen]

Boom! Keep up the good work, Reddy Rahman!

[@irfanabbassi9202]

Great ..excellent

[@NestorAdrianzen]

Thank you! Cheers!

[@abdulqadeerkamangar6279]

Instead of total profit, I have counts, how can filter based on top 5 country and product from multiple columns

[@NestorAdrianzen]

Abdulqadeer, Thanks for your question. What you can do is create a measure for counts and then use it in the Top N feature within the Filters pane. I hope it helps. Cheers!

[@abdulqadeerkamangar6279]

@@NestorAdrianzen thanks a lot, but I have already used one topN foe products and it's not allowing me to select another TopN for countries