Another question with Alternate States

[Remco]

You guys make my learning curve go quick! Thanks!

But here we go again, another question.

I have 2 states, each one has a selected value so I just get 2 dimensions if I do the following:

=Aggr(only({[State A] + [State B]} FORECASTID),FORECASTID)

This works great and I can make a simple count  of a field 'IDCONTRACT' or whatever measure:

 What I want to do is split up in 4 lines:

1) ID 209 and where IDCONTRACT is in both State A and State B

2) ID 437 and where IDCONTRACT is in both State B and State A

2) ID 209 and where IDCONTRACT is in State A but not in State B

3) ID 437 and where IDCONTRACT is in State B but not in State A

meaning that there must be a column between ID (that is the FORECASTID in the example above) and Count (counting the IDCONTRACT's)

Who could give me a clue of how to proceed?

Thanks!

[Remco · Accepted solution]

Never mind, I solved it:

=if(aggr(only({[State B]} IDCONTRACT),IDCONTRACT) = aggr(only({[State A]} IDCONTRACT),IDCONTRACT),'Continued Business',
if(aggr(only({[State A] + [State B]} IDCONTRACT),IDCONTRACT) = aggr(only({[State A]} IDCONTRACT),IDCONTRACT),'New Business',
'Discontinued Business'
)
)