@charris Agreed that this would be very useful. I believe the reason this can be done in Power BI and Tableau because they allow you to create relationships.
FYI there’s another discussion about this particular topic at How to filter multiple datasets using a single filter originating from a separate dataset in Analysis? - #4 by Koushik_Muthanna