3 Replies Latest reply on Feb 23, 2018 10:27 AM by Deepak Rai

    Cannot mix agg and non-agg

    Saran De

      Hi Team,

       

      I am two weeks old in Tableau. I am facing the subjected issue when I tried with the below Measure.

       

      CHG_Exp_%

      COUNTD(IIF([CHG Values]='X',[CHG Number],NULL))

      /

      {FIXED [CHG Attr]: COUNTD([CHG Number])}

       

      I am attaching the file for reference. Please let me know if you have any questions.