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

      2018-02-20_1447.png

       

       

       

      Picture 2

      2018-02-20_1447_001.png