Power BI DAX Tutorial (4/50) - What is calculate Function

What is Calculate Function in DAX, What is Calculate function how the filter works in that function How to filter a value in DAX , If you want get only Sum(Sales) only for particular location or Year how to achieve it. Power BI DAX Tutorial with Examples

#powerbi #powerbidax #CALCULATE

Datasource Link

Complete Playlists

BI Developer - Complete Reference - Playlist
BI Architect - Complete Reference - Playlist

[narasimhanaiduvardhineni]

Hi Nag Thanks for all the videos regarding Power bi. Trust me this Chanel going to be one of the best in power BI keep Doing 👍👍

[devarajanmurugesan]

Hi Nags, thank you for preparing this full length dax course. It is very useful. Especially explaining with scenarios. However, i have a small suggestion that before start using dax function, it would be really useful to fully understand the functionality of the dax or criteria required for it. For example Calculate(expression, filter1, filter2...). If you can explain this formula fully before start using it, will let us know the functionality of the dax.The current method appears a person who has some level of knowledge only, will be able to grasp the concept fully. Once again, thank you for your courses.

[sarazam]

Very clearly explained. I was stuck at this topic and searching for better explanation, this video explained everything I wanted to know. Thank you Nags.

[bezawitarage]

the best powerbi instructor i have ever seen the most importamt thing is you provide us the datas i downloaded them and playing with them following you, keep doing this good job you here for us tahnks nags you are blessed

[siddheshdandagavhal]

1) Power BI is a columnar database. So the dimensions can only be used in axis.
2) To Calculate all location sales use: Calculate(sum(data[sales]), ALL(data[location])), Here filter context is overwritten only for location column.
3) To Calculate all sales use: Calculate(sum(data[sales]), ALL(data)), Here filter context is overwritten for the entire data.

[Khan-mcgi]

First time i find great channel you explain in a great way to dax with business intelligence i request u pls make video question and answer for power bi which ask in interview

[ShreyasSinha]

Nag Sir, Best Channel, clear n simple easy to understand examples. Thank You so much Nag Sir 🙏

[nnpfffn.]

Big Thank from Thailand bro. what a explanation and show example.

[josephraj]

Hi Sir, Super duper way of explaining. Really very logical way of teaching. Watched many youtube channels but didn't come accross that way you teach. I have subscribed and want to follow you.

[___DannyBoyka]

Excellent explanation sir! I am joining as a BA soon, so glad to find your video at this time

[ahmedbagazi]

Thank you so much for sharing brother. Much appreciated from KSA

[hahaying]

It time to learn very good all time, thank you again

[sidindian]

Your explanation on DAX - part by part .. excellent Sir 🙂

[saranyav]

thankyou so much for the videos.you are the best teacher

[umeshsuggalaoffical]

Hi Nag, i have one query regarding the filter concept mentioned at last of the video. In all loc sales measure we are mentioning it as ALL[Data] so that any column filter cant apply on that measure..my qstn is what if we have filter from another table i.e. data2 which has date table..how to avoid that scenario..pls ans this qstn

[anujanand]

Just one question when you used all location total sales the last one in which use all and calculate now the filter started working there how come ? The percentage one I am asking about .

[keithwong]

at 8:32, instead of creaitng the All Loc Sales measure, can i skip creating that and directly get the % of sales? I'm imagining like nesting the All Loc Sales into the % of sales measure..

[vishalmane]

sir, all those dax functions u taught wud suffice our daily needs in real time screnario ?

[vjethk]

Hello Nags. Can you please make a video highlighting the difference between calculate and calculatetable?

[azizahmedkhan]

so calculate function is more like conditional if, aggregating values based on condition, like SUMIF, COUNTIF, AVERAGEIF etc in EXCEL