Understanding CALCULATE in DAX: Filters

Getting a thorough understanding of DAX helps you in creating amazing reports. In CALCULATE, your filtering arguments are key here in changing the evaluation context. Restrict your context or remove filters and much more!

Master Functions and Syntax in M

ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.

SUPPORT MY CHANNEL

SUBSCRIBE TO MY CHANNEL

LET'S CONNECT:

Thank you for your support!

#PowerBI #Calculate #BIGorilla

[andreashermle]

very well explained, thank you very much for these insights into this function

[masgitz]

Great video, thank you. I have difficulty using filtering in calculate when I'm trying to use another measure as the condition.

[emilylee]

Thank you so much for the training! I am struggling with how to exclude February 29 (02/29) in my sales calculation since 2024 is a leap year. I tried the formula below but no luck, the result is blank. Would you be able to help me?
PYSalesSamePeriod:=CALCULATE([SalesSamePeriodLastYear], 'Calendar'[Date2] <> "02/29")

[williamarthur]

Good introduction and well explained as ever, here it comes, I would have liked to see
the 'long' syntax for the two table filter, as i think that's better when learning how things actually work together. BTW loved the fibonacci sequence.

[decentmendreams]

Thank you so much . When am I going to get a breakthrough on Filters ? I understand everything but can’t write it free flow like you and other pros .In order for me to get to that level I need to understand it as much as I understand 2+2= 4. Otherwise all I do now for complex filter Daxes is copy and paste.

[rogelioluna]

What do you do if you want to filter 2 color?

[markhenderson]

How can I use OR with a filter instead of AND?

[pandianselvaraj]

I need to get max date for each equipment number with condtion
If service =x then max date
Else '' '

SELECT EQUIPMENT_NBR, MAX(CASE WHEN IN_SERVICE_IND = 'y' then NEXT_INSPECTION_DATE ELSE '2001-01-01 00:00:00' END ) AS maxdate FROM vari.VESSEL_INSPECT_VIEW group by equipment_nbr

With above i am getting business logic

But when i am try join this table with main table ..i am getting error ..bcz we have duplicate equipment number ..
Equipment number with sevice x, y, blank

If you have any idea pls help me