Semi Additive Measure in Bar Chart

[hlines_usacs]

Hello,

I am trying to create a bar chart using a semi-additive measure and cannot seem to get the correct expression syntax using the FirstSortedValue expression. 

Please see screen shot below. I would like the bar chart to show the number of Comms for the most recent Service Period (blue boxes), and not the total (red boxes). This is like a bank balance where it cannot be summed over time. Would someone be able to suggest how I can achieve this?

[rupamjyotidas]

Try using Dimensionality

  If( Dimensionality() = 0, <Total line expression>, <Individual line expression> )