Why is my cross-report drill through not working?

[HamidBee]

Hi All,

I created two reports, a source and target. I have enabled cross-report drill through but it isn't working. I am attaching a link to each file as well as screenshots below.

Source File: https://www.mediafire.com/file/2r3n1933qpu8w7n/Source.pbix/file

 

Target File: https://www.mediafire.com/file/5rb0f1ncelqggf7/Target.pbix/file# 

Any help would be greatly appreciated.

Thank you,

[HamidBee · Accepted solution]

I have fixed the problem. I switched on cross filter for the source file and it worked!. Unfortunately I watched a Guy in a Cube video where I was told not to switch it on and that it should only be switched on for the target file. Now I know that the cross filter needs to be switched on for both files.

At 4:25 he says don't touch it but it won't work otherwise. I believe the video needs to be updated.

https://www.youtube.com/watch?v=OcZr_70OGPo