Don't make these CALCULATE Function Mistakes! ⚠️

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

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
@ChrisSmithFW
@ChrisSmithFW Жыл бұрын
Fantastic! Thanks so much.
@IvanCortinas_ES
@IvanCortinas_ES Жыл бұрын
Wise advices. Thanks Chandeep!
@komanguy
@komanguy Жыл бұрын
Excellent explanation! Thanks a lot
@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❤
@SP_Investments
@SP_Investments Жыл бұрын
Thank you !
@theg9811
@theg9811 Жыл бұрын
Love it Chandeep, keep up the grate work!
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Thanks G!
@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
@vedantakilambi5708
@vedantakilambi5708 Жыл бұрын
great explanation
@emilmubarakshin49
@emilmubarakshin49 Жыл бұрын
very cool, thank you Chandeep for bringing us this gems of your experience!
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you like this Emil!
@renedoucet2849
@renedoucet2849 Жыл бұрын
So good! You make understanding DAX so much easier...
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad it was helpful Rene!
@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.
@nirmitshah6162
@nirmitshah6162 Жыл бұрын
This is a gem. Thanks
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you like this Nirmit!
@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.
@AccessAnalytic
@AccessAnalytic Жыл бұрын
Good explanation Chandeep
@pouravsahoo7159
@pouravsahoo7159 Жыл бұрын
Could you please help on how to add drill down to a Stacked bar chart
@martyc5674
@martyc5674 Жыл бұрын
This is one for the favorites folder 😊
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Awesome Martin! Glad to hear
@kennethstephani692
@kennethstephani692 Жыл бұрын
Great video!
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you like this Kenneth!
@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!
@sudbn
@sudbn Жыл бұрын
Great video thanks from Nepal
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you like this Sudip!
@shomiksarbabidya2712
@shomiksarbabidya2712 Жыл бұрын
Can you please explain why we can't use measure as a filter parameter in calculate function?
@UU-ry6gt
@UU-ry6gt Жыл бұрын
Very cool and useful stuff, even for pro user!
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad it was useful!
@tubeitz
@tubeitz Жыл бұрын
super
@amilawijesena1672
@amilawijesena1672 11 ай бұрын
Greatest
@adilumr6359
@adilumr6359 Жыл бұрын
Great video sir
@GoodlyChandeep
@GoodlyChandeep Жыл бұрын
Glad you like this Adil!
@RawShooters
@RawShooters Ай бұрын
Please kindly give details how to get fortnight figures just as we get for QTD AND YTD.. dynamically
@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?
@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
@pouravsahoo7159
@pouravsahoo7159 Жыл бұрын
While drilling down it is converting to a cluster bar
@adityakumarsrivastav3677
@adityakumarsrivastav3677 23 күн бұрын
Filter ( All(sales), Sales[Channel] = "xyz") OR Filter ( All(sales[Channel]), Sales[Channel] = "xyz") Which one is correct ? @goodly
@ndm2221
@ndm2221 2 күн бұрын
😅😇🙏🏾
@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 М.
Context Transition in Power BI and Tricky Examples
15:06
Goodly
Рет қаралды 39 М.
1 класс vs 11 класс  (игрушка)
00:30
БЕРТ
Рет қаралды 3,5 МЛН
Китайка и Пчелка 4 серия😂😆
00:19
KITAYKA
Рет қаралды 3,6 МЛН
Super gymnastics 😍🫣
00:15
Lexa_Merin
Рет қаралды 90 МЛН
Countries Treat the Heart of Palestine #countryballs
00:13
CountryZ
Рет қаралды 24 МЛН
9 Tiny but Super Useful Power BI Hacks
11:15
Goodly
Рет қаралды 15 М.
DAX Fridays! #78: When should I use FILTER() with CALCULATE?
11:35
I Bet You Don't Know All These Power Query Tricks
12:28
Goodly
Рет қаралды 36 М.
5 Surprising Power Query Tricks You Need to Know!
14:14
Goodly
Рет қаралды 29 М.
List.Accumulate in Power Query with Practical Examples
27:26
Understanding CALCULATE in DAX: Filters
18:01
BI Gorilla
Рет қаралды 16 М.
Row Context and Context Transition
16:47
Goodly
Рет қаралды 43 М.
How To Unlock Your iphone With Your Voice
0:34
요루퐁 yorupong
Рет қаралды 22 МЛН
keren sih #iphone #apple
0:16
Muhammad Arsyad
Рет қаралды 1,6 МЛН
Мечта Каждого Геймера
0:59
ЖЕЛЕЗНЫЙ КОРОЛЬ
Рет қаралды 1,2 МЛН
Samsung S24 Ultra professional shooting kit #shorts
0:12
Photographer Army
Рет қаралды 15 МЛН