DAX Fridays! #78: When should I use FILTER() with CALCULATE?

When should you use the filter function with CALCULATE?
As you probably have noticed, sometimes people use a column in the filter part of CALCULATE and sometimes they use the FILTER function.

The question is, when should you use what?
In this video I will try to clarify that question.

Dont miss part 2 where we talk about KEEPFILTERS: https://youtu.be/DnI7XNRGeCA

Download the file here: https://curbal.com/blog/glossary/calculate-dax

Here you will find all the previous CALCULATE and FILTER function tutorials.
https://curbal.com/blog/glossary/calculate-dax
https://curbal.com/blog/glossary/filter-dax
Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU

Link to DAX Fridays survey: http://bit.ly/2MMM4KK
Looking for a download file? Go to our Download Center: https://curbal.com/donwload-center

SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1

Our PLAYLISTS:
- Join our DAX Fridays! Series: https://goo.gl/FtUWUX
- Power BI dashboards for beginners: https://goo.gl/9YzyDP
- Power BI Tips & Tricks: https://goo.gl/H6kUbP
- Power Bi and Google Analytics: https://goo.gl/ZNsY8l

ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: http://www.curbal.com/contact

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

https://curbal.com/product/sponsor-me

Many thanks in advance!

▲▲▲▲▲▲▲▲▲▲

************

What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!

https://www.amazon.com/shop/curbal

************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +: https://goo.gl/rvIBDP
► Facebook: https://goo.gl/bME2sB

#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP

Видео DAX Fridays! #78: When should I use FILTER() with CALCULATE? канала Curbal