3 of 3 people found this helpful
First calculate the segment sales using your actual sales measure. I've used Superstores data to create a similar scenario like yours.
I've create a parameter like yours using Segment dimension.
Then created a calc field to calculated the sales of segments using parameter.
Then using segment sales calculated measure to lookup previous value.
Feel free to ask If you've any question.
Excellent! Thanks so much! It looks like my mistake was using the [Segment] in the detail. By filtering [Segment] explicitly within the calculation, it eliminates the need for this. I'm guessing because [Segment] was in the detail, it wouldn't allow it to show values that didn't match to a single [Segment],