At 7:26, if you pause and look at the results, the numbers don't make sense. Revenue by manager name seems to be more than the real result. It has somehow allocated sales per manager. Can you please explain why this has happened?
I think this happened because each manager is listed to be in many regions so they carry over the total vs just a portion. So essentially double dipping
HI , this does not seem to be right , if I look at your final " by Manager name report" (7:27) and sum up the values assigned to each manager it is almost 120mil and not 82
agree. And i dont understand how pbi can return the revenue of each manager? Because we only know the revenue of each region, for example Midwest has 50k revenue, but there are 2 managers in Midwest, so how to define the revenue of each manager
so well explained on this important topic. Thank you so much for making this effective video ? Just a small info required, can we see how the SQL is geared at the background while creating report visualization ?
Thank You. Bi-directional filters can get tricky in case of complex data models and should be cautiously set. They might cause ambiguity if multiple tables and relationships exist by presenting multiple navigation paths for the query. So, evaluating the complete data model is very important. Some developers also like to make use of the CROSSFILTER function to achieve the same objective. Hope this helps a bit :-)
why is the relationship between Manager and Region is Many-to-one and not many-to-many when one region can have multiple managers and one manager can be assigned to multiple regions?
by far the best explanation on this topic I have watched on this platform .
Thank you
Rarely to find the instructor explain this important topic. Thanks for an excellent tutorial.
Thank you 🙏
Yeah, I found the best example for cross filter direction 👌👌, Without talking too much, the girl jumped to the actual scenario 🤩
One of the best explanations on this topic !
Thank you
At 7:26, if you pause and look at the results, the numbers don't make sense. Revenue by manager name seems to be more than the real result. It has somehow allocated sales per manager. Can you please explain why this has happened?
I think this happened because each manager is listed to be in many regions so they carry over the total vs just a portion. So essentially double dipping
HI , this does not seem to be right , if I look at your final " by Manager name report" (7:27) and sum up the values assigned to each manager it is almost 120mil and not 82
agree. And i dont understand how pbi can return the revenue of each manager? Because we only know the revenue of each region, for example Midwest has 50k revenue, but there are 2 managers in Midwest, so how to define the revenue of each manager
Its really worth for developers... Thank you
Thank you
Thank you so much! Very well-explained
Thank you
Nice explanation thanks,keep it up.
Thank You!
hey it really helped me thanks for uploading please make separate videos on relationships cardinaLITY AND CROSS FILTER THANKYOU SO MUCH
Thank you. We will post detailed videos soon.
@@LearnatKnowstar your welcome I appreciate that
Great explanations . Many thanks
Glad it was helpful 🙏
@LearnatKnowstar, why using a bridge table in between. When you have region name in sales table and Manager table too??
Bridge tables are needed to resolve many to many relationships.
Can i get the data sets??
I love you. Good explanation
You are a "MAGICIAN"
Thank you
so well explained on this important topic. Thank you so much for making this effective video ? Just a small info required, can we see how the SQL is geared at the background while creating report visualization ?
Can we remove the region table and link manager and sales tables by region name ?
Amazing !!! Hats off to you !
Thank you so much!
Good video.. if i may ask, does changing the filter direction to both cause problems? One instructor adviced to not use bidirectional
Thank You. Bi-directional filters can get tricky in case of complex data models and should be cautiously set. They might cause ambiguity if multiple tables and relationships exist by presenting multiple navigation paths for the query.
So, evaluating the complete data model is very important.
Some developers also like to make use of the CROSSFILTER function to achieve the same objective.
Hope this helps a bit :-)
beautifully explained
Thank you 🙏
It's good, thanks.
Thanks so much
why is the relationship between Manager and Region is Many-to-one and not many-to-many when one region can have multiple managers and one manager can be assigned to multiple regions?
EXCELLENT
Thank you
but im show in Excel power query, its not showing that option in edit relationship...
00:31
instead we can connect manager table with sales table
why data source is not available mam
😂
thanks
Very well Explained. Thank You
Glad it was helpful.