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
powerquery.how
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: paypal.me/rickmaurinus.
Website: gorilla.bi
SUBSCRIBE TO MY CHANNEL
kzbin.info?sub_con...
LET'S CONNECT:
Blog: gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#PowerBI #Calculate #BIGorilla

[@sjpark6782]

I like your step by step explanation.

[@felipesignorellireis7839]

Great explanation.

[@andreashermle2716]

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

[@muskhha]

Very handy and useful

[@luda_c]

Excellent channel, thank you!

[@drindataviz-xd5db]

thank you for this!

[@williamarthur4801]

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.

[@alexrosen8762]

Great tutorial. Thanks :-)

[@BIGorilla]

Thank you!

[@user-hz6gw3uk6z]

thank you.

[@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.

[@jps11086]

Thanks

[@BIGorilla]

🔥🙌

[@rogelioluna4220]

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

[@Lightscripture]

This was great,, thank you! Also, I am trying to do something similar. I have 2 tables, T1= all orders. T2= errors. I need to calculate the percentage of errors for each client(where the list is in the thousands) based on the client name, and then filter by date. The logic I came up with was : error percentage = calculate[count(order errors) / count(total orders)] , CUSTOMER NAME CONDITION , but I am not quit sure how to do the syntax. Any help would be greatly appreciated! or if you have a more elegant solution I will take it too! Thank you!

[@markhenderson3771]

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

[@shwetajuyal4106]

&& for AND and || for OR

[@pandianselvaraj9204]

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

[@BIGorilla]

Hi Pandian. I'm afraid I don't follow the example. Hope you solved it!