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.
@@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.
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.
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
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.
Hello, First of all Thanks for all these videos! Ok, as we know there are multiple ways to get your result in this case we can simple - We can use a pie chart with Location and a measure for total Sales this will give us the % and a better visual analysis. Power BI experts add your method what you will do for this?
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
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.
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..
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, 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
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 .
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
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" )
@@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.
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.
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 ...
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
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
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 ??
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.
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
Hello, First of all Thanks for all these videos!
Ok, as we know there are multiple ways to get your result in this case we can simple
- We can use a pie chart with Location and a measure for total Sales this will give us the % and a better visual analysis.
Power BI experts add your method what you will do for this?
Big Thank from Thailand bro. what a explanation and show example.
Thanks. Keep learning share this channel with friends and colleagues
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
Great video! For chennai sales, What I need to remove the repeating values. Also I am creating a measure with 2 different tables
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
Thank you so much for sharing brother. Much appreciated from KSA
My pleasure
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
It time to learn very good all time, thank you again
You are welcome!
Your explanation on DAX - part by part .. excellent Sir 🙂
Thanks keep learning share this channel with friends and colleagues
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.
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?
sir, all those dax functions u taught wud suffice our daily needs in real time screnario ?
For using all in calculate function we can just use sum function ..
Go through DAX playlist first 10 videos you will understand better
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
so calculate function is more like conditional if, aggregating values based on condition, like SUMIF, COUNTIF, AVERAGEIF etc in EXCEL
Watch it again
so nicely explained
Thanks keep learning share this channel with friends and colleagues
nicely explained.......thanks
Glad you liked it
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, Thanks for video. Pls mention datasource link in the description.
File uploaded. Download and learn. Keep learning
@@AnalyticswithNags Thanku
Thank you
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, 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
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..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 , really got this topic
Hi Nag,
Can we use CALCULATE() without any kind of filter?
Yes you can do it.
Calculate ( sum(amount)) and sum(amount) is same...
If I want sales of location Chennai and product Jeans Levis then I how we can create Measure ?
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
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
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.
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
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/
very usefull
Glad to hear that
Thanks
Glad to help
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
can you share the above file for practice
It is in description of the video
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
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