Show values not linked to a selection

[elinamcastelletta]

Hi, I have 2 tables like below. 

S	A
1	x
1	b
2	c

A	D
x	x1
x	x2
b	b3
b	b4
c	x1
c	x3
c	x4

I created a dimension within a table. The idea is to show unique D values not linked to S.

1st case when no S selected, 2nd case for S selected:

=aggr(if(GetSelectedCount(S)=0,

              only(distinct{<D=E({<S={*}>})>}D),          -------> this works
              only(distinct{$<D=E(1{<S=P(S)>})>}D))    ---------> this doesn't work
    ,D)

How can I fix this?

Expected result:

         if I select  S=1 I want to see:

                                                              x3

                                                             x4

Thanks,

[sunny_talwar]

@elinamcastelletta May be try this

=Aggr(
  If(GetSelectedCount(S) = 0,
    Only({$<D = E({<S={*}>})>} D),
    Only({$<D = E({<S=P(S)>}), S>}D)
  )
, D)

[elinamcastelletta]

Hi, thanks but I doesn't work.