Sometimes you want to connect tables using more than one join. This is fine when performing a DAX calculation but what about drilling?
In this short Sam covers how to use an inactive relationship to filter the data when drilling.
Thank you for the awesome question by the talented Sehrish Aslam:
https://uk.linkedin.com/in/sehrish-aslam-1545a5100
Files here:
https://www.wiseowl.co.uk/power-bi/shorts/power-bi/inactive_drill/
