Need help to suggest about use Set analysis in dimension

[panwipa2528]

1. I have raw data as & sample as attach file

2. Table raw data just show all data

3. Table 2 Show Member

4. Table 3 Need help, find active member condition is
      4.1 [Member Status] =1
      4.2 sum(Sale) >0
 
If you have any question please let me know.

[Vegar · Accepted solution]

Try this expression

=If(aggr(([Member Status]=1) * (Sum(Sale)>0), [Member ID]),
   'Member', 
   'Non Member')