Don't make these CALCULATE Function Mistakes! ⚠️

  Рет қаралды 28,475

Goodly

Goodly

Күн бұрын

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 - goodly.wordpress@gmail.com
===== 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!

Пікірлер: 46
@komanguy
@komanguy Жыл бұрын
Excellent explanation! Thanks a lot
@ChrisSmithFW
@ChrisSmithFW Жыл бұрын
Fantastic! Thanks so much.
@IvanCortinas_ES
@IvanCortinas_ES Жыл бұрын
Wise advices. Thanks Chandeep!
@SP_Investments
@SP_Investments Жыл бұрын
Thank you !
@GeertDelmulle
@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! :-)
@HappyAnalysing
@HappyAnalysing Жыл бұрын
So helpful!!! Please do more n more of this type❤
@theg9811
@theg9811 Жыл бұрын
Love it Chandeep, keep up the grate work!
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Thanks G!
@hamishmaxa6509
@hamishmaxa6509 Жыл бұрын
"Please Work" doesn't return a table, but {"Please Work"} does I think? Try that at the start maybe? Great video. As always.
@vedantakilambi5708
@vedantakilambi5708 Жыл бұрын
great explanation
@AccessAnalytic
@AccessAnalytic Жыл бұрын
Good explanation Chandeep
@emilmubarakshin49
@emilmubarakshin49 Жыл бұрын
very cool, thank you Chandeep for bringing us this gems of your experience!
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you like this Emil!
@williamarthur4801
@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.
@renedoucet2849
@renedoucet2849 Жыл бұрын
So good! You make understanding DAX so much easier...
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad it was helpful Rene!
@sbn4862
@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
@nirmitshah6162
@nirmitshah6162 Жыл бұрын
This is a gem. Thanks
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you like this Nirmit!
@kennethstephani692
@kennethstephani692 Жыл бұрын
Great video!
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you like this Kenneth!
@martyc5674
@martyc5674 Жыл бұрын
This is one for the favorites folder 😊
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Awesome Martin! Glad to hear
@ravishmahajan9314
@ravishmahajan9314 5 ай бұрын
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.
@digdin12345
@digdin12345 Жыл бұрын
Great!
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Thanks SHU SHU!
@UU-ry6gt
@UU-ry6gt Жыл бұрын
Very cool and useful stuff, even for pro user!
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad it was useful!
@pouravsahoo7159
@pouravsahoo7159 Жыл бұрын
Could you please help on how to add drill down to a Stacked bar chart
@RawShooters
@RawShooters Ай бұрын
Please kindly give details how to get fortnight figures just as we get for QTD AND YTD.. dynamically
@sudbn
@sudbn Жыл бұрын
Great video thanks from Nepal
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you like this Sudip!
@tubeitz
@tubeitz Жыл бұрын
super
@adilumr6359
@adilumr6359 Жыл бұрын
Great video sir
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you like this Adil!
@shomiksarbabidya2712
@shomiksarbabidya2712 Жыл бұрын
Can you please explain why we can't use measure as a filter parameter in calculate function?
@amilawijesena1672
@amilawijesena1672 11 ай бұрын
Greatest
@mohammedgouse5512
@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
@rodelharvey
@rodelharvey 8 ай бұрын
Can you use values(Calendar[Date]) instead of just Calendar?
@adityakumarsrivastav3677
@adityakumarsrivastav3677 Ай бұрын
Filter ( All(sales), Sales[Channel] = "xyz") OR Filter ( All(sales[Channel]), Sales[Channel] = "xyz") Which one is correct ? @goodly
@pouravsahoo7159
@pouravsahoo7159 Жыл бұрын
While drilling down it is converting to a cluster bar
@sharpunk3
@sharpunk3 8 ай бұрын
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
@ndm2221
@ndm2221 10 күн бұрын
😅😇🙏🏾
@chadweber1351
@chadweber1351 4 ай бұрын
That intro 😂
@BizzByPritesh
@BizzByPritesh 2 ай бұрын
Your explanation are phenomenol. but here is an advise, "acche khase mard lag rahe, fir thumbnail q aisa dal diya"😂
@brianjulius6401
@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. 😆
Highlight Values below Target in Power BI
10:47
Goodly
Рет қаралды 17 М.
Excel LAMBDA - HOW & WHEN you Should use it
16:02
Leila Gharani
Рет қаралды 426 М.
🌊Насколько Глубокий Океан ? #shorts
00:42
Which one of them is cooler?😎 @potapova_blog
00:45
Filaretiki
Рет қаралды 10 МЛН
Make an Interactive Excel Dashboard in 4 Simple Steps!
19:41
Kenji Explains
Рет қаралды 167 М.
Context Transition in Power BI and Tricky Examples
15:06
Goodly
Рет қаралды 39 М.
5 Best Practices in Power Query
11:31
Goodly
Рет қаралды 46 М.
DAX Fridays! #78: When should I use FILTER() with CALCULATE?
11:35
5 Surprising Power Query Tricks You Need to Know!
14:14
Goodly
Рет қаралды 29 М.
Introducing CALCULATE in DAX
13:57
SQLBI
Рет қаралды 73 М.
Non-Sticky Slicer Trick in Power BI
17:38
Goodly
Рет қаралды 9 М.
3 Insanely Awesome Slicer Tricks in Power BI 🤯
15:35
Goodly
Рет қаралды 13 М.
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 193 М.
Asus  VivoBook Винда за 8 часов!
1:00
Sergey Delaisy
Рет қаралды 881 М.
Секретный смартфон Apple без камеры для работы на АЭС
0:22
Урна с айфонами!
0:30
По ту сторону Гугла
Рет қаралды 7 МЛН
#miniphone
0:16
Miniphone
Рет қаралды 3,4 МЛН