Net movement between categories

Thanks for your reply. It certainly works re the calculation logic.

The issue I have is that I would like to show the movement between specific categories, i.e.:

Prior   Current   Net

Affiliate   Fellow   +2

Member   Fellow   -4

Affiliate   Member   +6

I can't quite work out how I want to handle this, because there will always be an equal and opposite movement for each Prior / Current combination, so the total movement will = 0.

I guess I need to define the Prior / Current category combinations, but not sure how to go about that.

Thanks for taking the time to work up the pbix and replying.

Rich