No video
How to Specify Multiple Filter Conditions in CALCULATE [Power BI]
Рет қаралды 27,929
Күн бұрынIn this lesson, I will teach you how to specify multiple filters conditions in CALCULATE.
Please navigate through the content below:
0:40 Agenda
1:10 Syntax sugar
1:55 Complete CALCULATE syntax
2:51 Referencing multiple columns in the same predicate
4:07 Case
Content Link: drive.google.c...
___________
Highly recommended Power BI books (Affiliate links):
***The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition: amzn.to/3ldPLpk
***DAX Patterns (Second Edition): amzn.to/3fBKdnD
***Analyzing Data with Power BI and Power Pivot for Excel: amzn.to/3fDPLOd
***Beginning DAX with Power BI: amzn.to/3fDEe1k
***Storytelling with Data: A Data Visualization Guide for Business Professionals: amzn.to/3mfPcwE
***Storytelling with Data: Let's Practice!: amzn.to/36c6Cot
***Information Dashboard Design: amzn.to/2V61o7h
___________Relevant PBI Topics
- MEASURES vs CALCULATED COLUMNS in DAX: • MEASURES vs CALCULATED...
- How to Use the ALL DAX Function in Power BI: • How to Use the ALL DAX...
- How to Use the Filter DAX Function in Power BI [The Basics]: • How to Use the Filter ...
- How to Calculate PERCENTAGES in Power BI: • How to Calculate PERCE...
- How to COMBINE Tables in Power BI: • How to COMBINE Tables ...
____________
[DISCLAIMER]: Some links included in this description might be affiliate links. If you purchase a product with those links, I might receive a small commission. However, there is no additional charge to you! I appreciate your support and this will help me provide you with free content on a weekly basis.
If you like the content, feel free to buy me a cup of coffee 😀👇www.paypal.me/...
If you don't want to miss anything, subscribe to our newsletter: vizxlization.c...
___________Please follow us on:
Web: www.vizxlizati...
LinkedIn: / vizxlization
Twitter: / vizxlization
Facebook: / vizxlization
Instagram: / nestoradrianzen
Leave your comments and questions below!
Don't forget to subscribe!
Thanks so much!
#CALCULATE #DAX #vizxlization
@bzflowerbee 3 жыл бұрын
Simple and easy to understand as always! Appreciate it!
@NestorAdrianzen 3 жыл бұрын
Thanks for your feedback, Bzflowerbee. Keep it up! 👊
@davidbourgeois3981 2 жыл бұрын
Thank you! One of the rare times that I actually saw what I needed within the first few minutes. Appreciate it!
@NestorAdrianzen 2 жыл бұрын
David, Thanks for your feedback and keep up the great work!👍
@pavelsantiago1308 2 жыл бұрын
You Are the best bro!
@NestorAdrianzen 2 жыл бұрын
Excellent! Keep it 🆙, Pavel.
@sophyrath9299 2 жыл бұрын
Love you! you are the best! easy to understand.
@NestorAdrianzen 2 жыл бұрын
Glad it was helpful, Sophy Rath. Keep up the great work👍
@michafabich9213 2 жыл бұрын
really appreciate your tutorials, amazing stuff
@NestorAdrianzen 2 жыл бұрын
Thanks for your support, Michal!
@IvanCortinas_ES 2 жыл бұрын
Supreme video. Thumbs up!!!! Thank you Nestor.
@NestorAdrianzen 2 жыл бұрын
Excellent! Glad this video was helpful.
@nataliaberra5628 2 жыл бұрын
Thank you! you saved my day!
@NestorAdrianzen 2 жыл бұрын
Glad you found it helpful, Natalia. Keep it 🆙
@erdalyayvan654 3 жыл бұрын
Another great video! Keep up the good work👍
@NestorAdrianzen 3 жыл бұрын
Glad to hear that! Keep it up, Erdal! 👊
@miller1520 2 жыл бұрын
You're a great help, thanks!!
@NestorAdrianzen 2 жыл бұрын
Excellent! Keep it 🆙 👍
@irfanabbassi9202 2 жыл бұрын
Great ..excellent
@NestorAdrianzen 2 жыл бұрын
Thank you! Cheers!
@sravankumar1767 3 жыл бұрын
Nice explanation 👌
@NestorAdrianzen 3 жыл бұрын
Glad you found it helpful. Keep it up, Sravan Kumar!
@rahman3344 3 жыл бұрын
Love you much more for your knowledge and yours Boom 💥💥💥💥 also
@NestorAdrianzen 3 жыл бұрын
Boom! Keep up the good work, Reddy Rahman!
@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() )
@ahshineyaca 4 ай бұрын
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 4 ай бұрын
You will want to use IN {“product1”, “product2”}
@ahshineyaca 4 ай бұрын
Thank you!
@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"} )
@barneybear3937 2 жыл бұрын
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 2 жыл бұрын
Barneybear, Thanks for checking the content! Make sure that the KEEPFILTERS function covers the whole expression with parenthesis. I hope this helps!
@abdulqadeerkamangar6279 2 жыл бұрын
Instead of total profit, I have counts, how can filter based on top 5 country and product from multiple columns
@NestorAdrianzen 2 жыл бұрын
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 2 жыл бұрын
@@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
Family Games Media
Рет қаралды 29 МЛН
Lighthouse Analytix
Рет қаралды 14 М.
Nestor Adrianzen
Рет қаралды 21 М.