4 Replies Latest reply: Mar 16, 2018 8:05 AM by Jonathan Dienst RSS

    How to count the Output of a Measure

    Michael Gauntlett

      Hi Guys,

       

      So I have

       

      IF(IsNull(AARO_Booking_Period) and IsNull(Status),'R0',If (IsNull(Status),'R1',Status),'R0')

       

      Which I created as a measure to Output either 'Status' or R0/R1.

       

      I would like to try and develop a methos where I can take this Master Status Measure and run a Count IF.

       

      So how many R0 are there for the UK etc.

       

      I have tried 

       

      Sum(Aggr( IF(IsNull(AARO_Booking_Period) and IsNull(Status),'R0',If (IsNull(Status),'R1',Status),'R0'), [Master Status]))

       

      but it does not work

       

      Any Ideas would be greatly appreciated.

       

      Many Thanks