2 Replies Latest reply on Feb 20, 2018 1:17 PM by Diogo Braga

    Measure Calculation

    Diogo Braga

      This calculation below works with COUNTD and a Running Total applied later and returns the desired visual. Picture 1.


      IF [Academic Year]="2017-2018" THEN (IF NOT ISNULL([Unique ID])

      THEN [Unique ID]

      END) END


      However, I'd like to embed the count and running total into the calculation so the calculation result is a measure.

      I tried this, but it's not working. Look at Picture 2.



      IF MIN([Academic Year])="2017-2018" THEN RUNNING_SUM(IF NOT ISNULL(COUNTD([Unique ID]))

      THEN (COUNTD([Unique ID]))

      END) END


      Picture 1





      Picture 2