Relationship DAX Functions in Power BI | USERLATIONSHIP And CROSSFILTER DAX Function

[@nazmulhaque3894]

Awesome 👌

[@itneka]

Thank you very much.. Very well made video

[@ameyraj4947]

Informative and well explained

[@carterlayton6792]

You prolly dont care but if you're bored like me during the covid times then you can watch pretty much all of the latest movies on InstaFlixxer. I've been watching with my gf for the last few weeks =)

[@deshawnenrique5006]

@Carter Layton Yup, I have been watching on instaflixxer for years myself :)

[@atlasdallas5042]

@Carter Layton yup, I've been watching on InstaFlixxer for since november myself :)

[@leonallan8602]

@Carter Layton yup, I've been using instaflixxer for since november myself =)

[@hectorotis1291]

@Carter Layton yea, I have been using InstaFlixxer for since november myself :D

[@ashishjuneja6574]

Hi, Great explanation !! I have a peculiar issue where I need to display all records from 2 different dimensions without filtering based on Fact table. I see probably a similar scenario in your data model defined by inactive relationship between Sales Territory and Employee. How / Where to use this relationship. Have you demonstrated this in any video ? Thanks

[@mohitupadhayay1439]

Which of the two cases is more reliable and effificent?

[@BIConsultingPro]

Both have their on pros and cons. You need to see what fits for you. Please check the remarks under Microsoft DAX docs

[@usmansharifshaik1187]

Hi, However, calculation of total sales -based USERELATIONSHIP dax function with [ship date key] to [date key] and without using userrelationship dax function i.e already defined active relationship with [datekey] to [orderdate key] gives the same result. what is the difference then?

[@aravindkumarkalicheti3014]

Hello, Given nice explanations.. i have been searching for one information from long time but it is not properly available.. can you please make a video on issues that faced in matrix table total column. some times it comes the text value and some times if we use any if and else functions on matrix total column also affecting.. can you plz help me on that?

[@BIConsultingPro]

May I ask you to email your query with an example to [e-mail]

[@cesarsaldana3429]

Hello, I am a follower of your channel, it would be helpful if you would provide us with the link to download the data model, which you use in your demonstrations. Greetings from Mexico

[@BIConsultingPro]

Please download from here! docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms

[@foziayimam4159]

We have a common data model so when we use userelationship doesn't work is there any limitation when using this dax in CDM?

[@BIConsultingPro]

I am not sure! However, I request you to check here: docs.microsoft.com/en-us/dax/userelationship-function-dax

[@ashishmohan4707]

Hi Hope you are doing fine. very useful video and very practical need everyone for every project ......very big thanks to share with us. If it can possible can you plzz provide us excel data file which you used. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[@BIConsultingPro]

You can download the file from here: 1drv.ms/u/s!ApIf9f9Q3qOxkC7n4jFOxhL8fJjS?e=m5wBtq

[@itneka]

Can this be used for inactive many to many relationship

[@BIConsultingPro]

yes, you can

[@bhagyashrikulkarni5066]

What is the use of inactive relationship in powerbi?

[@BIConsultingPro]

It helps you to do calculations or to get value from another table using an inactive relationships. For example, the USERALTIONSHIP DAX function can take advantage of inactive relationships. For more details, please read here: docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive

[@SantoshKumar-yr2md]

sir can you have seperate video for power BI service, data model, dax, power query editor, please suggest

[@BIConsultingPro]

Hi, please go through our video lists. Everything is available there. * For the DA-100 Exam Tutorial Series: kzbin.info/aero/PLp4MAoTwZIfcBPbzGrQlCbUZqIl36n8vy * Row-Level Security in Power BI Tutorial Series: kzbin.info/aero/PLp4MAoTwZIfc9zn1G3U8jhe9BVFOzWZ7_ * Free Data Sources to Practice Power BI: kzbin.info/www/bejne/rmmnpJ-kobybg80 * For the DP-203 Exam Tutorial Series: kzbin.info/aero/PLp4MAoTwZIfc4bq4MIN398o6OiL65vvrC * Power BI Admin Tutorials Series: kzbin.info/aero/PLp4MAoTwZIfeH00b8G8UyPiV6Ej5KKoXD * For more DAX Videos: kzbin.info/aero/PLp4MAoTwZIfcBuFYCLKeL5DULz8OOHky7 * For more Weekly Videos: kzbin.info/aero/PLp4MAoTwZIfcQKSr4DNyrWmrFxrCGN-oh * Power BI in Hindi: kzbin.info/aero/PLp4MAoTwZIfcXT8DJ3a8QsQtkYBOplQP_ * Power BI Free Data Sources: kzbin.info/www/bejne/rmmnpJ-kobybg80 * Data Modelling in Power BI: kzbin.info/aero/PLp4MAoTwZIffSWOZvcSI8MCVJo8UIOmVR ****************************************************************** 1. Power BI Crash Course: kzbin.info/www/bejne/qnfQlKSonbt9ock​ 2. How to pass DA-100 Exam: kzbin.info/www/bejne/gWSmqoOFr8h9iJo 3. Data Classification in Power BI: kzbin.info/www/bejne/gqiahHWOZp6ajKc​ 4. Sensitivity Labels in Power B: kzbin.info/www/bejne/nZDcgoytrLhnhtk 5. What is Power BI Service? kzbin.info/www/bejne/h4rclGh6apZnh80​ 6. Power BI Data Model Analysis: kzbin.info/www/bejne/fKK0dneLlJV_gMU 7. Filter Propagation Concept: kzbin.info/www/bejne/eZ_ZpGewadeYiqc 8. Dynamic Page Navigation with RLS Video: kzbin.info/www/bejne/fKOodY2Qjc6cqpo 9. Incremental Refresh in Power BI: kzbin.info/www/bejne/fGrSiqGnZtSgpKM 10. Create Date Table in Power BI: kzbin.info/www/bejne/rKrLk2mJrdVrY6M​ 11. Deployment Pipelines in Power BI: kzbin.info/www/bejne/hIa8e6uKo6d4eqc 12. XMLA EndPoint Connectivity in Power BI: kzbin.info/www/bejne/pqird5ese62Hhpo 13. RLS Vs OLS in Power BI: kzbin.info/www/bejne/ZoXNkIenl995g68 14. Power BI Data Gateway: kzbin.info/www/bejne/mYSnnIGQgJenoZo 15. Anomaly Detection in Power BI: kzbin.info/www/bejne/kH-QdWZubbWGrKc 16. Smart Narrative Visual in Power BI: kzbin.info/www/bejne/g6HbeYyOf6ydbKc 17. Free Datasources for Power BI: kzbin.info/www/bejne/rmmnpJ-kobybg80

[@govardann6831]

I have one doubt. I have yeardate in slicer, when I click the year in slicer it will show max value in the column chart as well as show the maxvalue of month Name as header.

[@BIConsultingPro]

I am sorry but I didn't get your question. May I ask you to please write your question with an example like in excel (expected result) at [e-mail]

[@Laxmanmane007]

Hello sir what is power apps how we can use with power bi

[@BIConsultingPro]

Power Apps are part of Microsoft Power Platform which uses no-code platform. For more info: powerapps.microsoft.com/en-us/