@@AnalyticswithNags and if we want to count product subcategories by country which is another table,how can we use cross filter because product subcategories not directly connected to fact table rather it is connected to product table ,and product table is connected to fact table by 1 to m
is it possible in power bi, when you view your main report and click on a row or data point in the specified visual, Power BI will navigate to the drill-through page
can anyone tell/guide me what other tools/technology required other than power BI and sql for 3+ years of experience ? i have 5years of experience in testing and planning to move into BI due lack of growth , please someone guide me what to learn from where to learn, to manage/handle work as 3+plus y of experience in the market, i m looking for live project-based training any help/ lead will be appreciated. Thanks
@@AnalyticswithNags Thank you so much sir for the support, is there any project video that can help to be ready for the market as experienced and manage work by own in the industry
Already explained in that video while explaining for experience professional. Anyway here is the link to real time projects playlist Power BI Project Dashboards - Power BI Realtime Projects - Playlist: ruclips.net/p/PLjNd3r1KLjQty8rRYWwTUhS_gnzk0f2VK
That my question as well. The Total does not much for all the countries distinct count of color. @analyticswithNags: Should it be the Sum of the distinct count of all countries? Thanks
Thanks bro for the beautiful example.. it was crisp and clear explanation... 🙏🏼
Thanks keep learning. Share this channel with friends and colleagues
these dax functions are sufficient or is there any more functions we lean?
Learning this will make you to handle most of the scenarios in real time. I can say 80% of cases and other functions you will use as and when required
u made it very simple to understand
Glad to help
Hi Nags
Can we instead enable Cross filtering in one Dim and Fact Table instead of Using DAX?
Yes
Again another very simple to understand video. Suggest you put training videos on Udemy as well...
Thanks keep learning. Due to time constraints we can’t able to make other videos
Hi sir,what if there are multiple tables like product, product subcategories, product categories and we need to sum sales only bike product category.
Either combine the tables into single product table or relate the tables that will work without issues
@@AnalyticswithNags and if we want to count product subcategories by country which is another table,how can we use cross filter because product subcategories not directly connected to fact table rather it is connected to product table ,and product table is connected to fact table by 1 to m
is it possible in power bi, when you view your main report and click on a row or data point in the specified visual, Power BI will navigate to the drill-through page
Yes. Search for drill through video in the channel
But there is only one direction from Dim sales to Fact table..so, how we can get from Dim Prod table to Dim sales?
Not sure about your question
can anyone tell/guide me what other tools/technology required other than power BI and sql for 3+ years of experience ?
i have 5years of experience in testing and planning to move into BI due lack of growth , please someone guide me
what to learn from where to learn, to manage/handle work as 3+plus y of experience in the market, i m looking for live project-based training any help/ lead will be appreciated. Thanks
Answered in this video
ruclips.net/video/_4l7Esu70iw/видео.html
@@AnalyticswithNags Thank you so much sir for the support, is there any project video that can help to be ready for the market as experienced and manage work by own in the industry
Already explained in that video while explaining for experience professional.
Anyway here is the link to real time projects playlist
Power BI Project Dashboards - Power BI Realtime Projects - Playlist: ruclips.net/p/PLjNd3r1KLjQty8rRYWwTUhS_gnzk0f2VK
Thanks For explanation, I have one doubt here total 8, each country total count is 7,2, 3, 8 but total is 8
Yes in total only 8 products available . It is distinct count not additive
That my question as well. The Total does not much for all the countries distinct count of color. @analyticswithNags: Should it be the Sum of the distinct count of all countries? Thanks
how we can identify the Territory table is filtering the fact table?
Check playlists of this channel and explore topics on the similar line requested by you.
Data set is not in the description, please share
Dataset not shared with anyone
@@AnalyticswithNags then whole purpose of the video is lost without data set
How complex DAX queries they will ask to 3 years experienced guy?
It depends on interviewer. Check the most used DAX functions video
The example is copied in my head that even i want to forget it will not , thanks
Welcome
Hi, please share dataset so we can practice.
we dont maintain excel , prepare your own file like the one shown , with your own sample data.
sir plz share dataset used in this particular video
Check description