CALCULATE Function in DAX

Learn how the CALCULATE function works in DAX.

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-
- - - - Blog - - - -

[anupamabasu]

Love the superman analogy! Makes complete sense. Thank you!!!

[SMITDEDHIA]

W.O.W.
I'd have used this function dozens & dozens of times but finally understood the concept - big credit goes to Superman analogy!
Thank you so much, boss!

[eslamfahmy]

Actually, it's the first tutorial I can't understand well, but you are still Superman of Dax 😊

[marliearcellia]

I really love the way you put it up so systematic and explained about how the function works and why it doesn't work. Thank you so much and please keep posting about Power BI

[robinc.]

Your videos have been very helpful to me! I appreciate your teaching style and the examples are clear and practical.

[arunv]

funny thing, he solved the issue and came up with a video of how we can not use if not blank and still achieve, thank bro, you evolve and help us too a lot

[phorton]

A true Rosetta Stone! Perhaps the best explanation I have heard on Calculation. Dhanwaad Ji!

[Krishnauniyal]

you explain calculate function very well thanks for that, i have one question can we use measure instead of column
in filter condition

[MrStivi]

Very well explained. I like the superman example.

[pravinshingadia]

Thank you for your awesome work! Please keep it up - you're easily one of the best

[PK-iunc]

Hi Goodly,

At the timestamp 7:16, Why did you added -1 at the end of the calculate formula. The function SAMEPERIODLASTYEAR() itself results in previous year values right. By dividing the current year and previous year values, we come to know the growth percentage right.

Kindly clear this doubt. Anyone in the comment section can answer.

[hk_k]

This is the only calculate I can understand the first time! Can you do a few more. If possible, talk about adding sales from different tables, assume each team has thier own sales tables. Putting them in same matrix column.

[digantsheth]

Great work, well explained, just one question, why -1 at the end when calculating % ??

[wayneedmondson]

Awesome Chandeep! Thanks for the clear explanation about the CALCULATE function. Thumbs up!!

[vishaljhaveri]

This is a wonderful video. Thank You, Chandeep!

[sonalijain]

After seeing the multiple videos i was not getting the functionality of calculate function but this video is gem...Very well explained just one small request can u be little slower in videos.

[rnflutes]

Super clear. Well explained filter override

[aahanavikram]

Thanks a lot..
Now I can understand calculate function

[HARITHAK-ds]

You explained function well, give the dataset link in the descripition and practise wise

[ankeet]

Chandeep, I am trying to create a simple calculation within PBI. My table has 2 columns - Scheduled Hours and Hours Worked. Each row in the table represents a shift worked by an employee. I want to create Overtime measure, where if Hours Worked > Scheduled Hours then return Hours Worked - Scheduled Hours else return zero. How do I go about doing this while creating a measure?