Don't make these CALCULATE Function Mistakes! ⚠️

In this video, we will know about 4 common mistakes with CALCULATE Function and how to fix them!
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/calculate-functi...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[@komanguy]

Excellent explanation! Thanks a lot

[@IvanCortinas_ES]

Wise advices. Thanks Chandeep!

[@GeertDelmulle]

This is a great video! Need more of this type. Allows us to understand better what is going on and why. Good format, good job! :-)

[@ChrisSmithFW]

Fantastic! Thanks so much.

[@HappyAnalysing]

So helpful!!! Please do more n more of this type❤

[@SP_Investments]

Thank you !

[@hamishmaxa6509]

"Please Work" doesn't return a table, but {"Please Work"} does I think? Try that at the start maybe? Great video. As always.

[@williamarthur4801]

These theory type videos always welcome, as are all your offerings. One thing, re Measure not working when declared as a variable first, I had the opposite problem when creating an index in dax, . OneV:=IF(HASONEVALUE(Table1[Test]),VALUES(Table1[Test])) Index:= OneV VAR:=VAR onev = [OneV] RETURN CALCULATE([CountR],FILTER(ALL(Table1[Test]), ISONORAFTER(Table1[Test], onev, DESC))) But if I just put the OneV measure in directly it did not work? any ideas.

[@sbn4862]

my favorite channel ever!!! Your explanation methods is the best of all Thank you for all Chandeep. I have a question. For example MAXX(Sale, CALCULATE([SalesAmount], All(Date[Date]) We have context transition, And the Sale table at Many side. Is the context transition separates from Sale table to Date table?. I used All(Date[Date]) to stop context transition. But to tell the truth I can’t imagine the behavior expanded table, how it works. Can you explain it When we set filter to the table not on column, when we have context transition inside iterators. Thank you

[@theg9811]

Love it Chandeep, keep up the grate work!

[@GoodlyChandeep]

Thanks G!

[@AccessAnalytic]

Good explanation Chandeep

[@vedantakilambi5708]

great explanation

[@pouravsahoo7159]

Could you please help on how to add drill down to a Stacked bar chart

[@emilmubarakshin49]

very cool, thank you Chandeep for bringing us this gems of your experience!

[@GoodlyChandeep]

Glad you like this Emil!

[@renedoucet2849]

So good! You make understanding DAX so much easier...

[@GoodlyChandeep]

Glad it was helpful Rene!

[@ravishmahajan9314]

So i have one question, in CALCUALTE, filter need to be a table. So can you please explain how those filtered tables and existing filter context work with each other to calculate final measure in CALCULATE? Actually i am not able to visualize how different tables both in calculate & filter context sync with each other to calculate measure in modified filter context. I guess this is where people get confused.

[@shomiksarbabidya2712]

Can you please explain why we can't use measure as a filter parameter in calculate function?

[@nirmitshah6162]

This is a gem. Thanks

[@GoodlyChandeep]

Glad you like this Nirmit!

[@mohammedgouse5512]

Hi could you please create video Dax query Evaluation which will Execute first like If we have Used many variables calculate among all this which will Execute first

[@martyc5674]

This is one for the favorites folder 😊

[@GoodlyChandeep]

Awesome Martin! Glad to hear

[@kennethstephani692]

Great video!

[@GoodlyChandeep]

Glad you like this Kenneth!

[@RawShooters]

Please kindly give details how to get fortnight figures just as we get for QTD AND YTD.. dynamically

[@digdin12345]

Great!

[@GoodlyChandeep]

Thanks SHU SHU!

[@UU-ry6gt]

Very cool and useful stuff, even for pro user!

[@GoodlyChandeep]

Glad it was useful!

[@sudbn]

Great video thanks from Nepal

[@GoodlyChandeep]

Glad you like this Sudip!

[@rodelharvey]

Can you use values(Calendar[Date]) instead of just Calendar?

[@adilumr6359]

Great video sir

[@GoodlyChandeep]

Glad you like this Adil!

[@tubeitz]

super

[@amilawijesena1672]

Greatest

[@sharpunk3]

Thank you so much your explanation. May you please create a video or guide me pertaining to an alternative of using sameperiodlastyear, dateadd, where the date column is not unique and also primary key is like 1/1/2021-0000-0100 1/1/2021-0100-0200 This is happening because we are also calculating sales on hourly basis thats its like this. I am not able to create dynamic LY sales just like sameoeriodlastyear

[@adityakumarsrivastav3677]

Filter ( All(sales), Sales[Channel] = "xyz") OR Filter ( All(sales[Channel]), Sales[Channel] = "xyz") Which one is correct ? @goodly

[@pouravsahoo7159]

While drilling down it is converting to a cluster bar

[@chadweber1351]

That intro 😂

[@ndm2221]

😅😇🙏🏾

[@BizzByPritesh]

Your explanation are phenomenol. but here is an advise, "acche khase mard lag rahe, fir thumbnail q aisa dal diya"😂

[@brianjulius6401]

All of these problems simply go away if you stop using CALCULATE. I’m not saying’ I’m just sayin’ …¯\_(ツ)_/¯ Come join the dark side, Chandeep. 😆