Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try using Dimensionality
If( Dimensionality() = 0, <Total line expression>, <Individual line expression> )