2 Replies Latest reply: Jan 7, 2018 12:03 PM by krishna b RSS

    QS Extension table

    krishna b

      Hi All,

      How to write measures in  QS Extension table.

      Dimension: [Affected Device]

      Measure:

      if(GetSelectedCount(Affected_Month)>0,

      Round(Sum([Overall Availability%])/Count([Overall Availability%]))&''& '%',

      Round(Sum({<Affected_Date={'$(=Max(Affected_Date))'}>}[Overall Availability%])/

      Count({<Affected_Date={'$(=Max(Affected_Date))'}>}[Overall Availability%]))&''& '%')

       

      i need below out put based on data.

      Dimension: Valuelist('Status')

      Capture.PNG

      Regards,

      Krishna