Hi Alex, I'm enjoying your Power BI series, thanks for making these videos. They came just at the right time for me as my boss wants me to create her a Power BI dashboard to analyse job application statistics and I've never done it before. These videos will be a great starting point. Thanks again!
@@shripalmehta cos he didnt explain anything... this was a tutoriial on where are the buttons located.. both directional relationships should be mostly avoided from what i read so far and this video didnt contain any useful information whatsoever
Hi Alex! Loved the last 3 videos. They are really helpful id someone is a complete newbie in Power BI. Eagerly waiting for the whole playlist so that I can Binge-learn ;)
Following your YT channel and part of the Analyst Builder community. Thank you for all of your knowledge spilled out to others to make us better. I did have a question at the 7:45 mark. When it comes to the cross filter direction, should it always be listed as both for any relationship? Or is it specific to what the needs are of the data?
Hi Alex :) I really like Your videos, but in that paricular one I wouldn't recommend using both direction in relationships, especially for beginers. It may cause difficult to predict implications in more complex data models. I would recommend probably to use RELATED measure (but I am not an expert [yet]) ;)
hey Alex, thanks for the tutorial. I was thinking about the Single Cross Filter Direction, but I cound't find a reason to have it. is there a reason for having Single Direction? I feel like it should always be both
Dear Alex, Thanks for all you do, I really appreciate all the tutorials you put in here. This is just to notify you that I have been finding it difficult to download the dataset. I have tried all means but it is still the same, but it wasn't like this before. Kindly help look into it. Thank you.Regards.
Hi Alex - at 6:09 your total is 10. I did same thing and got a total of 74. I crossed checked with the data i excel and saw we had a total of 74 products sold. Please can you help clarify that ?Thank you so much Alex.
Hello. I think there is a confusion on the counting part because if we want to find how many product is sold by state, we should look sale and customer table. If im wrong please aware me
I have a question, when I am manually dragging the data I want to make connections it does not allow me. I have double checked the properties as that’s what it said online but I’m still unable to make the connection I want to
Can you explain more about the cross filter direction --> in other practice videos I've watched, you don't add the both direction. When do you need to adjust this?
Hi Alex, thank you for providing this Power BI tutorials. On this tutorial number 3, at video stamp 4:24, when clicking the dropdown arrow on the top table, it's not displaying the table 'Customer Information' to select. It's only showing 'Apocolypse Sales' and 'Apocolypse Store'. And on the bottom table, it's only showing two tables as well ----- the 'Customer Information' and 'Apocolypse Store'. I'm not sure why both the top and bottom tables are only displaying two tables, instead of three. Your input is very much appreciated so I could proceed with your tutorials. Thank you!
@alex the analyst when you were studying to become a Data analyst did you remember everything you trained for when you finally got a job or did you have to retrain again on the technical skills that were difficult for you ?
When I created a relationship it gave an error when I tried to change from one to many , to many to one. "Column 'Must ID" in Table 'Apocalypse Sales' contains a duplicate value '1234' and this is not allowed for columns on the side of many-to-one relationship or for columns that are used as the primary key of table. Please explain !
Hi Alex I have same heading names in different tables but when I load the data it is not exactly showing relation and if I try to relate it then I’m only able to do many to many can you please clarify what could be reason for it
For anyone who is still getting the 10,10,10,10 in the states and measures, make sure that you select "Make this relationship active", just under the cardinality drop down.
Was a little confused about the files (Customer Information Apocalypse Sale, and Apocalypses Store) being out of order like in the video (I say this bc I had issues updating the cardinality like he showed) but I pushed along by the end of it.
Hey Alex, would you know if it’s possible to have multiple active relationships for the same variable? My case is as follows: I have a SF object called projects which represent a business deal. The project has fields for multiple participants, such as buyer’s attorney and seller’s attorney which can be populated with an “organization” object. I’m trying to create a table that shows the 7 participant types across a project where I can use a single slicer and type in a single name (ex: XYZ Law Firm) and I can see all the projects they’re associated with regardless of role. How could I set these relationships up? Also, the results in the columns currently only show the SF ID value of the org, not the name
table result not showing when i chosse cross filter direction to both..my state become invisible and product id shows 10 rows single column.. any idea?.. after manual creating the relationship it works..
Hello Alex! Just to be clear, would you advice to keep the cross filter direction on single or both? Will this depend on the visualization outcome? (as you showed us the value "10" was the same for every case until you changed the relationship) Thank you!
are we using different data sets every video? seems vague when working with different data sets every time. i feel like we didnt even do much with the previous data sets and now we are using another one. i wish we can use the same data sets from start to finish.
Sit while creating the Relationship i m not having save option for relationship ... And after using another method of dragging and dropping still it is not working the relationship is not created .please help me sir
when building relationship, is it possible to have two tables that don't share any similarity but you create the similarity by copy a unique column from one table to the other sheet.. can that work ?
I have a question, why is the total like 10? For both times what is that total actually? Regardless of change both times it shows 10? If its a count total then surely the total of all states is not 10 is it?
I was trying to figure this out as well and went back to the Excel spreadsheet to figure it out. Under the Apocalypse Store there are 10 total Product IDs. The visualization in Power BI with the measure added is showing how many of each specific Product ID each store bought. So, Uncle Joe's Prep Shop is located in Dallas, Texas and it says Texas bought 10 in Power BI. That means they purchased something from all 10 Product IDs. Alex's store is in New York and they purchased something from 9 of the 10 Product IDs. The Total stays at 10 in the visualization because it's the total number of Product IDs. It's not the sum of what each state bought. A little confusing, but hope this helps.
Hi Alex. I have a pretty good level at Excel and I want to go ahead, to reach a higher level. So I think I should learn VBA. Buuuut I took a course on SQL and I watched many of your videos recently and you didn't mention VBA in any video. So now I'm not sure if learning VBA is worth it. What are your thoughts about it? I really appreciate yoour thoughts, so I hope you can answer me. Thanks a lot 💕
I'm not sure to understand the difference between both and single.. Ive been using single in so many PowerBI projects and I never had any issues with my data ! I am wondering what I am missing lol
It seems really hard to be able to get a Data Analyst job without a degree. What would you recommend to someone who’s currently working on his degree in IT in order to stand out? Would offering to work for a company for free (internship) be a good way to get “hired” and some experience on your resume? Thanks for all your information!
Don't work for free for someone else. Find some projects to do and do them on your own time. If it is about putting a company on your resume and you don't want to flat out lie. Create an LLC and make yourself an employee of your own company. Some good beginner(emphasis on beginner) curriculums to get a base from are the google data analyst or the IBM data analyst.
‘Model tutorial’ doesn’t seem to be available to me as part of the file download. There is ‘bin lists tutorial’, ‘conditional formatting tutorial’, ‘DAX Tutorial’, ‘drill down tutorial’, ‘power query editor tutorial’, ‘relationship tutorial’ and ‘apocalypse food prep’ but not ‘model tutorial’, am I missing something?
Not sure how the customer to sales can me many:many. It has to be 1:many. One Customer can have multiple purchase IDs but a purchase ID can have only one Customer ID.
@@AlexTheAnalyst so just like in Tableau, you can’t just switch tabs and bring columns to your visualization? It is kind of surprising for such a brilliant tools that they haven’t built it what seems to be a simple function/solution. Maybe I am not aware but that’s what I am experiencing. Still new to all this.
It would have been better if you'd explained when to use Single and when to use Both for cross-filter direction. In fact, I don't even know what "cross-filter" means?!
Yes, when I watched this video first time , I couldn't get anything then I watched again for clarity that what Alex actually deliver in this video, eventually I understood whole video 😊
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
thanks for the relationship advice
Lol any time 😂
What I learned is that a relationship should work in both directions. And if it doesn't, we have a problem
Good one😂😂
Thanks Alex, for making so easy and straight to the point.
So perfect! Helped me realize why my page-level filters were not working. Had to change from "single" to "both" directions. Thank you!
Going over, your Power BI tutorials for beginners, I love them
I'm glad you have come to the light side (power bi) of the force, Jedi Alex.
Hi Alex, I'm enjoying your Power BI series, thanks for making these videos. They came just at the right time for me as my boss wants me to create her a Power BI dashboard to analyse job application statistics and I've never done it before. These videos will be a great starting point. Thanks again!
Did you manage to create a dashboard for yo boss? Did she like it?
I didn't understand where to use single relation , I felt that I have always to make it both
Thank Mr.
same
same!
@@shripalmehta cos he didnt explain anything... this was a tutoriial on where are the buttons located.. both directional relationships should be mostly avoided from what i read so far and this video didnt contain any useful information whatsoever
I'm really enjoying your Power BI series! As always, THANK YOU!!
Hi - at 6:09 your total is 10 but this does not match the consolidated figure for all the states. Can you please explain why, thank you.
Hi Alex! Loved the last 3 videos. They are really helpful id someone is a complete newbie in Power BI. Eagerly waiting for the whole playlist so that I can Binge-learn ;)
The Model Tutorial file was renamed to Bins Lists Tutorial, if anyone is curious
Love you bro you are great you soved my problem that i faced for a long time
@alex In the new update, it doesnt let you flip the relationship like you did. FYI
You explained so well cardinality and many to one. Thank you !
Following your YT channel and part of the Analyst Builder community. Thank you for all of your knowledge spilled out to others to make us better. I did have a question at the 7:45 mark. When it comes to the cross filter direction, should it always be listed as both for any relationship? Or is it specific to what the needs are of the data?
same here... :(
Really enjoying your videos. Makes it so much easier. Thank you
Very easy to understand. Great Job!
Hi Alex :) I really like Your videos, but in that paricular one I wouldn't recommend using both direction in relationships, especially for beginers. It may cause difficult to predict implications in more complex data models. I would recommend probably to use RELATED measure (but I am not an expert [yet]) ;)
Great videos, like how compact and simple you make it. Thanks
Thanks a ton for these Alex!
hey Alex, thanks for the tutorial. I was thinking about the Single Cross Filter Direction, but I cound't find a reason to have it. is there a reason for having Single Direction? I feel like it should always be both
I'm thinking it might be performance-related.
Great Video Mosh !!!
This helps. I feel like I need a tutorial that is one level lower than this to understand the both to many and cardinally concept for KPI generation.
Wow this one was good! Thank you for always inspiring me to grind harder, whether at work or on YT. Keep doing what you do!
Nuhun pak Alex 🙏🙏
Dear Alex,
Thanks for all you do, I really appreciate all the tutorials you put in here.
This is just to notify you that I have been finding it difficult to download the dataset. I have tried all means but it is still the same, but it wasn't like this before.
Kindly help look into it.
Thank you.Regards.
Hi Alex, when you create or change a new measure, why the total is 10?
Amazing! Thank you
Thank you, the relationship expert! ;-)
Hi Alex - at 6:09 your total is 10. I did same thing and got a total of 74. I crossed checked with the data i excel and saw we had a total of 74 products sold. Please can you help clarify that ?Thank you so much Alex.
Cool, it is quite like those Entity Relationship diagrams.
Hello. I think there is a confusion on the counting part because if we want to find how many product is sold by state, we should look sale and customer table. If im wrong please aware me
I have a question, when I am manually dragging the data I want to make connections it does not allow me. I have double checked the properties as that’s what it said online but I’m still unable to make the connection I want to
Hi Alex, thank you for this IB educational videos. Please, explain the logic behind 'Make this relationship active'. I didn't quite get it. 🙂
Thank you, Alex.
I am just going through the videos but having difficulty downloading the datasets.
Any idea on how else to go about it?
Can you explain more about the cross filter direction --> in other practice videos I've watched, you don't add the both direction. When do you need to adjust this?
Thankyouuu, this video is really helpful
6:13 but whats up with the total being wrong?
Thanks for sharing your knowledge and effort.
Hi Alex, thank you for providing this Power BI tutorials. On this tutorial number 3, at video stamp 4:24, when clicking the dropdown arrow on the top table, it's not displaying the table 'Customer Information' to select. It's only showing 'Apocolypse Sales' and 'Apocolypse Store'. And on the bottom table, it's only showing two tables as well ----- the 'Customer Information' and 'Apocolypse Store'. I'm not sure why both the top and bottom tables are only displaying two tables, instead of three. Your input is very much appreciated so I could proceed with your tutorials. Thank you!
Same here
same problem ,tell me if you found the solution
Amazing short and useful
@alex the analyst when you were studying to become a Data analyst did you remember everything you trained for when you finally got a job or did you have to retrain again on the technical skills that were difficult for you ?
When I created a relationship it gave an error when I tried to change from one to many , to many to one.
"Column 'Must ID" in Table 'Apocalypse Sales' contains a duplicate value '1234' and this is not allowed for columns on the side of many-to-one relationship or for columns that are used as the primary key of table.
Please explain !
So if you have more then two tables and you want them all to be connected, choose for both in the crossfilter direction?
Great video. 🎉
Hi Alex I have same heading names in different tables but when I load the data it is not exactly showing relation and if I try to relate it then I’m only able to do many to many can you please clarify what could be reason for it
thanks man.
For anyone who is still getting the 10,10,10,10 in the states and measures, make sure that you select "Make this relationship active", just under the cardinality drop down.
What's the point of the single cross filter direction setup, if both gives you more accurate data?
Was a little confused about the files (Customer Information Apocalypse Sale, and Apocalypses Store) being out of order like in the video (I say this bc I had issues updating the cardinality like he showed) but I pushed along by the end of it.
yea thanks for the relationship advice!
Hey Alex, would you know if it’s possible to have multiple active relationships for the same variable?
My case is as follows: I have a SF object called projects which represent a business deal. The project has fields for multiple participants, such as buyer’s attorney and seller’s attorney which can be populated with an “organization” object. I’m trying to create a table that shows the 7 participant types across a project where I can use a single slicer and type in a single name (ex: XYZ Law Firm) and I can see all the projects they’re associated with regardless of role.
How could I set these relationships up? Also, the results in the columns currently only show the SF ID value of the org, not the name
another great video Alex love you babe
Liked and Subscribed. Thank you.
Man you're awesome
table result not showing when i chosse cross filter direction to both..my state become invisible and product id shows 10 rows single column.. any idea?.. after manual creating the relationship it works..
Is there a reason why the output against each store still shows 10 for me even when I change the cross-filter to both like Alex did?
I'd like to know too, as I am getting the same :(
hello, when you did the relationship in both. then in the table we had a total of 10. what this total value means ?
Same question
not able to download excel file for analysis please help asap
Hello Alex! Just to be clear, would you advice to keep the cross filter direction on single or both? Will this depend on the visualization outcome? (as you showed us the value "10" was the same for every case until you changed the relationship)
Thank you!
Definitely depends on what you're wanting to do with the data/visualization!
Please make a video on becoming a part time data analyst.
are we using different data sets every video? seems vague when working with different data sets every time. i feel like we didnt even do much with the previous data sets and now we are using another one. i wish we can use the same data sets from start to finish.
Sit while creating the Relationship i m not having save option for relationship ... And after using another method of dragging and dropping still it is not working the relationship is not created .please help me sir
Thanks 😊
Good video.
Hey can anyone help me why when i change my models its not reflecting in my reports?
Genius !
when building relationship, is it possible to have two tables that don't share any similarity but you create the similarity by copy a unique column from one table to the other sheet.. can that work ?
Great question. I would like to know as well.
What is really the function of the work of this relationship. I don't really know the use
I don't get the single or both arrow meaning in the relationship sir, please explain anyone
Hi Alex, please guide to install power bi for mac machine
I'd like to know too ...
Thanks!
Dax functions series please!
Alright done and will be released in a few weeks :)
I have a question, why is the total like 10? For both times what is that total actually? Regardless of change both times it shows 10? If its a count total then surely the total of all states is not 10 is it?
I was trying to figure this out as well and went back to the Excel spreadsheet to figure it out. Under the Apocalypse Store there are 10 total Product IDs. The visualization in Power BI with the measure added is showing how many of each specific Product ID each store bought. So, Uncle Joe's Prep Shop is located in Dallas, Texas and it says Texas bought 10 in Power BI. That means they purchased something from all 10 Product IDs. Alex's store is in New York and they purchased something from 9 of the 10 Product IDs. The Total stays at 10 in the visualization because it's the total number of Product IDs. It's not the sum of what each state bought. A little confusing, but hope this helps.
@jbmiller1122thank you sir ❤
Hi Alex. I have a pretty good level at Excel and I want to go ahead, to reach a higher level. So I think I should learn VBA. Buuuut I took a course on SQL and I watched many of your videos recently and you didn't mention VBA in any video. So now I'm not sure if learning VBA is worth it. What are your thoughts about it? I really appreciate yoour thoughts, so I hope you can answer me. Thanks a lot 💕
VBA is dying don’t worry about learning it 😊
the measure wont work i just only get blank on states and all result are 10
Can anyone explain to me why we set the filter to "both" and why that changed the count?
I'm not sure to understand the difference between both and single.. Ive been using single in so many PowerBI projects and I never had any issues with my data ! I am wondering what I am missing lol
Will you be making udemy courses in near future?
Others say you should avoid bidirectional relationships - so what would you advise a beginner?
As a beginner, I think this video is a little bit harder than other tutorials (SQL, Tableau)
It seems really hard to be able to get a Data Analyst job without a degree. What would you recommend to someone who’s currently working on his degree in IT in order to stand out? Would offering to work for a company for free (internship) be a good way to get “hired” and some experience on your resume? Thanks for all your information!
Don't work for free for someone else. Find some projects to do and do them on your own time. If it is about putting a company on your resume and you don't want to flat out lie. Create an LLC and make yourself an employee of your own company. Some good beginner(emphasis on beginner) curriculums to get a base from are the google data analyst or the IBM data analyst.
‘Model tutorial’ doesn’t seem to be available to me as part of the file download. There is ‘bin lists tutorial’, ‘conditional formatting tutorial’, ‘DAX Tutorial’, ‘drill down tutorial’, ‘power query editor tutorial’, ‘relationship tutorial’ and ‘apocalypse food prep’ but not ‘model tutorial’, am I missing something?
The Relationship Tutorial file is the file for this video
no video connecting through SQL Server
Not sure how the customer to sales can me many:many. It has to be 1:many. One Customer can have multiple purchase IDs but a purchase ID can have only one Customer ID.
So, this basically how you do left/right joins in data.
Big w
Wheres the Excel for this tutorial?
why is total not 74 ?
How is managing these relationships useful for creating a visualization?
Sometimes you need data from other tables or data sources. So being able to connect them all will help you create the visualizations you need.
@@AlexTheAnalyst so just like in Tableau, you can’t just switch tabs and bring columns to your visualization? It is kind of surprising for such a brilliant tools that they haven’t built it what seems to be a simple function/solution. Maybe I am not aware but that’s what I am experiencing. Still new to all this.
It would have been better if you'd explained when to use Single and when to use Both for cross-filter direction. In fact, I don't even know what "cross-filter" means?!
❤❤❤
Not helpful, your relationship works fine not notes or warning, whenever I do something it says warning or get hell outta here
Is Power BI free?
There is a free version and a paid version.
Instructions Unclear now I am sleeping on the couch.
Create old . You knowings .
BI . Overhills .
structure . ANALAYSTICS . Matching .
Session. On Microsoft
ms.visso online courses
I didn't get this sorry
Not Understood fully this third video.
There is the same data in 2 tables like customer_id and powerbi dont recognize it as the same data unless you connect it like Alex show
Yes, when I watched this video first time , I couldn't get anything then I watched again for clarity that what Alex actually deliver in this video, eventually I understood whole video 😊
Argh!!! You already have the relationships build 😑
In your Power BI playlist, 4 videos are still hidden 🥲 why?
I have them completed and on RUclips, but they're scheduled to be released in the next few weeks.