1 of 1 people found this helpful
limitations in cube:
With Microsoft Analysis Services connections, drill-down actions defined in the cube are not available in Tableau.
Cube data sources do not accept actions from relational or other cube data sources. See Actions.
If your cube supports actions then Use actions to get desired result.
Use the exclude option in action filter and solve this.
Source sheet as
Target as sheet 4 with exclude all values.
that helped me, thanks!