Power BI DAX Tutorial (4/50) - What is calculate Function
ฝัง
- เผยแพร่เมื่อ 4 ต.ค. 2024
- 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
drive.google.c...
🏬 Visit our Amazon Influencer Store 🏬 : www.amazon.in/...
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬 : t.me/analyticsw...
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Power Pivot 📚📖 • Power BI Tutorial (15/...
Power Query 📚📖 • Power BI Tutorial (15/...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Tamil Tutorials 📚📖 • How to do Power BI Ins...
Power BI Telugu Tutorials 📚📖 • How to do Power BI Ins...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 • Learn SQL Complete | C...
Data Analyst - Complete Reference - Playlist 📚📖 • Data Analytics For Beg...
BI Developer - Complete Reference - Playlist
📚📖 • Power BI Tutorial From...
BI Architect - Complete Reference - Playlist
📚📖 • Power BI Full Course -...
ETL Developer - Complete Reference - Playlist 📚📖 • Building an Enterprise...
Database Developer - Complete Reference - Playlist 📚📖 • SQL Tutorial - Full Da...
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 👍👍
Thanks for your wish. Keep learning.
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.
Noted. Thanks for your feedback. Keep learning share this channel with friends and colleagues
Yes it become very difficult for beginners to understand directly, it would be helpful if u explain DAX formula separately
@@hemantsrivastava2644 true! I had the same problem when I first started learning DAX. i stumbled into his videos and failed to understand the concept but no that I've learned the basics (on my own), I find it pretty easy to understand the DAX syntax taught by him.
@@Idgaf-1998what resource did you use for learning on your own?
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.
Thanks keep learning share this channel with friends and colleagues
Big Thank from Thailand bro. what a explanation and show example.
Thanks. Keep learning share this channel with friends and colleagues
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
Thanks keep learning share this channel with friends and colleagues
@@AnalyticswithNags Sir , can we connect SQL server to power BI file ??
Thank you so much for sharing brother. Much appreciated from KSA
My pleasure
Nag Sir, Best Channel, clear n simple easy to understand examples. Thank You so much Nag Sir 🙏
Thanks keep learning. If you are in LinkedIn talk about this channel
It time to learn very good all time, thank you again
You are welcome!
Great video! For chennai sales, What I need to remove the repeating values. Also I am creating a measure with 2 different tables
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
We will try
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.
Thanks and welcome
Thanks you it's very helpful
Welcome
thankyou so much for the videos.you are the best teacher
Glad you like them! Keep Learning
@@AnalyticswithNags sir can you please post a video for powerautomate. And power apps visual
Will plan in future.
so nicely explained
Thanks keep learning share this channel with friends and colleagues
nicely explained.......thanks
Glad you liked it
Your explanation on DAX - part by part .. excellent Sir 🙂
Thanks keep learning share this channel with friends and colleagues
Excellent explanation sir! I am joining as a BA soon, so glad to find your video at this time
Thanks keep learning share this channel with friends and colleagues
Thanks , really got this topic
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.
Thanks
Glad to help
very usefull
Glad to hear that
so calculate function is more like conditional if, aggregating values based on condition, like SUMIF, COUNTIF, AVERAGEIF etc in EXCEL
Watch it again
sir, all those dax functions u taught wud suffice our daily needs in real time screnario ?
Hello Nags. Can you please make a video highlighting the difference between calculate and calculatetable?
If time permits.
Calculate returns scalar value whereas calculate table returns table
@@AnalyticswithNags hi what if there are sub branches in each city and need to calculate sales with respect to city?
Hi sir one of best video is calculate(sum(data[loc],data) is same as calculate (sum(data[loc],all(data)) like we can use without all function?
All will remove filters from table
For using all in calculate function we can just use sum function ..
Go through DAX playlist first 10 videos you will understand better
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 .
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
Hi, Thanks for video. Pls mention datasource link in the description.
File uploaded. Download and learn. Keep learning
@@AnalyticswithNags Thanku
If I want sales of location Chennai and product Jeans Levis then I how we can create Measure ?
hi nag..is this dax playlist enough for real time work or nee to learn more dax functions
More than enough.
@@AnalyticswithNags thank you so much for this playlist ..
Thanks Nag for sharing your knowledge. Just wanted to check if you provide online classes? I am Interested in learning Power BI & other analytics tools.
Thanks for your message.
Currently we don't find time to take trainings, that is why we created the TH-cam channel that covers almost 90% of topics.
So, follow this playlist
Power BI Tutorials - Complete Playlist: th-cam.com/play/PLjNd3r1KLjQt0xN_y8F6BSIOVNvdQmq4d.html
If you want to clarify some points, you can join this telegram group and post your queries here.
t.me/analyticswithnags
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..
Yes you can
Hi Nag,
Can we use CALCULATE() without any kind of filter?
Yes you can do it.
Calculate ( sum(amount)) and sum(amount) is same...
Hi sir Thanks, found your videos awesome cant we do this way
Chennai Sales =
CALCULATE([Total Sales],
Data[Location] = "Chennai"
)
instead of your way
Chennai Sales =
CALCULATE(sum(Data[Sales Amount]),
Data[Location] = "Chennai"
)
Yes. But I hope total sales is again measure. Your code will run 2 Dax queries and my code will run only one Dax query
@@AnalyticswithNags thanks for the swift reply sir
but total sales measure we have already created earlier still will it run 2 codes in the background.
@@hiteshjoshi3148 yes because DAX measures are calculated every time you refresh your report. Hence performance wise sir's approach is good.
Hi, If we want to ignore multiple filters coming from 2 tables or different column from multiple table, then how can we use all function to ignore those filter coming from 2 tables, if you may help thanks
Can you eloborate your question
what is difference between caluclate and caluclate table?
Calculate is a function used to alter the filter context. Calculatetable returns the table as a result
Hello, found this very useful but after downloading source file why I'm getting differnce in total sales value it shows 4,501,100 but your 5196 please help
Ignore the values. I am not exactly uploaded the files that I have used in the videos. It might be modified version as well
You should verify your results with your source system data. I.e in excel you should cross verify.
@@AnalyticswithNags thanks you
bro,
data will be exiting one table it possible when data will be contain two tables like location will be contain one table ,sale will be contain another table then now how to do it
Not able to understand your questions
Hi sir, i have a doubt on Using All with column name & with Table name , The Table which we are using instead of column is in same table or from different ..
Total Sales with column = CALCULATE(SUM(FactInternetSales[SalesAmount]),all(DimSalesTerritory[SalesTerritoryCountry]))
All Sales with Table = CALCULATE(SUM(FactInternetSales[SalesAmount]),ALL(FactInternetSales))
when im using above measure its giving proper result as you mentioned in video...but instead of Factinternet sales if using DimsalesTerritory not giving result ...
Explore the similar problems here, learn.microsoft.com/en-us/answers/
Hi Nag , i have one doubt when we are apply all function it applicable filters only for columns, why it should not applicable for tables..
Watch this Video you will get answer by understanding this. th-cam.com/video/TyDCNZdrTJc/w-d-xo.html
can you share the above file for practice
It is in description of the video
Is there azure videos class and interested to buy videos
There is a playlist related to azure. Which is ongoing will be available soon
Thank you so much nags can u hav watsapp group to join
Check description, you can join telegram group
Analytics With Nags
t.me/analyticswithnags
Thank you @@AnalyticswithNags