SQL query join with nested select

SSAS and SSRS
4

Thank you so much for the help. This looks like it may work. I am tweaking it now.

Thanks,

Karen