Configure Drillthrough for Measures with USERELATIONSHIP by using Calculation Groups in Power BI

This video shows you how to use drillthrough with measures that use USERELATIONSHIP in Power BI. USERELATIONSHIP changes the relationship measures follow in a data model. And implementing this for drillthrough has some intracacies you should take into account. Calculation Groups are your best friend here.
Master Functions and Syntax in M
powerquery.how
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: paypal.me/rickmaurinus.
Website: gorilla.bi
SUBSCRIBE TO MY CHANNEL
kzbin.info?sub_con...
LET'S CONNECT:
Blog: gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
00:00 Introduction
00:43 Drillthrough challenge: USERELATIONSHIP
03:02 Setting up Drillthrough
#drillthrough # userelationship #powerbi

[@johnsapplications]

honestly, you're TOP 3 in succinct delivery for PBI content. Concise and to the point, good examples.

Again another cool video Rick! 👍 Thanks!

[@nishantkumar9570]

Awesome use of Calculation group.

[@mnowako]

Yeah, it’s powerful! Thank you! 👏

[@BIGorilla]

Thanks Mariusz, it's incredible. Love the possibilities!

[@rowanschoultz1022]

Heel slim, bedankt Rick.

[@NearbyCactus]

This is fantastic - excellent video!

[@BIGorilla]

Thanks, highly appreciated Tim 🙏🔥

[@GoodlyChandeep]

Nifty!

[@ainsufia1616]

Hi. I wonder if drillthrough can be use for multiple measure in matrix table. Will the filter applied in each measure reflected to the drillthrough table. Hope you can advise😊

[@BIGorilla]

Hey Ain. Drillthrough does the following. It takes the filter context of your current cel, and passes that filter to the drillthrough table. You can achieve it with: - specific columns. If you drag a column as your drillthrough table dependency, only tables that have that column can drillthrough - you can use a measure so that only visuals with that measure will drillthrough to the drillthrough table. Regardless of the method, the drillthrough filters only come from the cell’s filter context. The filters applied within your measures will not reach the drillthrough table. You can however show your measure 📏 in your drillthrough tabel

[@tanayrajjhagadiawala8790]

You are doing an awesome job. I got so many solutions from your videos. But I am stuck at one point. I am creating a sales report for my company. for that each month I get txt file. The size of each file is around 150mb. For that, I also have to combine old data. data for the years 2019,2020 and 2021. now the thing is, I also get patient data. now, I want to give the patient's id. Based on the patient's name and DOB. The challenge is Patient's id should only be given if that patient coming for the first time. if the patient comes again after two years, an old id should be given. One more condition; all patient information should not be included in a data model. I have to delete all columns except the patient's id. How can I do this? please help me. I am stuck at this point for while. Thank you in advance. Keep going.

[@BIGorilla]

Thanks Tanayraj, I'm glad to hear you're enjoying the videos. The case you're describing does not seem to relate to this video and would fall under consultancy. If you're in need of consultancy you can reach out to me through my website gorilla.bi.

[@raeesg]

Followed each of the steps very carefully and exactly, but unable to replicate with a simple countrow measure :( - it is still using the active relationship.

[@raeesg]

Found the issue, it was a prerequisite, the measures with the use relationship have to be included in the 'underlying data' table on the page that you are drill through-ing into.

[@BIGorilla]

Awesome! Glad you found it 🙏