Here is a nifty CALCULATE function trick to filter between dimension tables or apply a reverse filter from a fact to a dimension table.
Enjoy!

- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
https://goodly.co.in/learn-dax-powerbi/

✔️ Power Query Course-
https://goodly.co.in/learn-power-query/

✔️ Master Excel Step by Step-
https://goodly.co.in/learn-excel/

✔️ Business Intelligence Dashboards-
https://goodly.co.in/learn-excel-dash...

- - - - Blog - - - -
https://goodly.co.in/blog

---
Artist Attribution
Music By: "After The Fall"
Track Name: "Tears Of Gaia"
Published by: Chill Out Records
- Source: https://goo.gl/fh3rEJ​
Official After The Fall YouTube Channel Below
https://www.youtube.com/channel/UCGQE...
License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0)
Full license here: https://creativecommons.org/licenses