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?